LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices



Reply
 
Search this Thread
Old 05-28-2005, 12:18 PM   #1
ojav
LQ Newbie
 
Registered: May 2005
Location: Finland
Distribution: Sol
Posts: 7

Rep: Reputation: 0
cyrillic chars - unicode or koi8_ru


Hi
I am making a website, which will have pages also in Russian. I've managed to insert cyrillic characters in the mysql (3.23.55) database. But am I right assuming that Php 4.3.0 does not support koi8_ru charset.

The other option would be to use Unicode (UTF-8 ) But then, am I right assuming that Mysql 3.23.55 does not support Unicode. And I am not finding any documentation about whether Mysql 4.0 would support Unicode or not.

I am sort of a newbie to all this and I dread the idea of upgrading either Mysql or Php, because my previous experience tells me that with my inadequate skills the server will anyway be down for days (or even weeks).

What do you think would be the least trouble's way:
a) to upgrade PhP to support koi8_ru
b) to upgrade Mysql to support Unicode (will 4.0 do it?)
c) neither of the above. But what?

Please help!

PS my server is SoL 16 which is a bit old distro, but because it's been running so smoothly and beautifully, I REALLY dread the idea of upgrading it. But can I count on it supporting Unicode? Again the documentation I find about it makes no mention about Unicode either way. But at least some configuration-xml-files in the system have encoding="UTF-8". Does that settle it?
 
Old 05-29-2005, 03:51 PM   #2
Mara
Moderator
 
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,539

Rep: Reputation: 149Reputation: 149
In 4.1 you have the following character sets: http://dev.mysql.com/doc/mysql/en/charset-charsets.html (UTF-8 is on the list, can't find it for 4.0).

In my opinion it's easiest to use UTF8. You probably need to upgrade MySQL. When you're upgrading, get the latest production version (4.x). It'll require some effort, but will solve your problem for sure.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
international chars awl Slackware 8 09-01-2005 02:17 PM
Cyrillic ?! manatwork Linux - Software 23 08-24-2005 08:18 PM
cyrillic chars - should I upgrade mysql or php ojav Linux - Software 0 05-29-2005 05:46 AM
Cyrillic abxbx Slackware 14 08-19-2004 02:42 AM
chars } and $ won't work.. among others.. apax Linux - Newbie 8 11-26-2003 10:20 AM


All times are GMT -5. The time now is 07:38 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration