Storing non-english language in MySQL db

[Geee]

I need to store some non-english language content in a database to serve to the users depending on the language their system uses. The problem I'm having is storing the non-english characters in the database. The first data I have received is in Russain script. It looks like MySQL converts this to unicode chars when I paste the info in a test database. Has anyone done anything like this before? If so, any pointers would help me out no-end.

-Geeeeeeeeeeeeeeeeeeeeeeee-
-=

http://www.gtmconsult.co.uk=-

 

[sleipnir214]

What version of MySQL are you using? What column-type are you using to store the data?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[Geee]

MySQL version is 3.23.58.
The column type I'm using at the moment is LongText (as some of the content is a few paragraphs long.

-Geeeeeeeeeeeeeeeeeeeeeeee-
-=

http://www.gtmconsult.co.uk=-

 

[sleipnir214]

To the best of my knowledge, unicode columntypes are not well-supported in MySQL until version 4.1.

You might try storing the unicode information in BLOB columntypes.

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[rockstardub]

Hey, I've been all about this stuff lately.
I'm makin' a English/German/Russian website, and I've been where you are.

Here's the gig, it really has nothing to do with the database.
store your info in the column as text, and if you look at the data in the database, it might look strange, but...

If you create a PHP form to enter the text to submit your data to the database, then that it will work.

Just throw this in the top of all of your PHP pages,

<meta HTTP-EQUIV="content-type" CONTENT="text/html; charset=UTF-8">

Your problem is not in the database, its in the PHP.

- Rockstar dUb