Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
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!


  Search this Thread
Old 05-28-2005, 11:18 AM   #1
LQ Newbie
Registered: May 2005
Location: Finland
Distribution: Sol
Posts: 7

Rep: Reputation: 0
cyrillic chars - unicode or koi8_ru

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, 02:51 PM   #2
Registered: Feb 2002
Location: Grenoble
Distribution: Debian
Posts: 9,696

Rep: Reputation: 232Reputation: 232Reputation: 232
In 4.1 you have the following character sets: (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.


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 01:17 PM
Cyrillic ?! manatwork Linux - Software 23 08-24-2005 07:18 PM
cyrillic chars - should I upgrade mysql or php ojav Linux - Software 0 05-29-2005 04:46 AM
Cyrillic abxbx Slackware 14 08-19-2004 01:42 AM
chars } and $ won't work.. among others.. apax Linux - Newbie 8 11-26-2003 09:20 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:01 PM.

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