mysql 3.23.54 and UTF-8

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have a site on a server using ASP and MySQL 3.23.54 (Cobalt Raq server)

I have been asked to convert the site to Unicode and need to know:

1) If MySQL 3.23 supports unicode
2) How do I change the existing data to Unicode
3) Any more help or resources would be much appreciated.



Re: mysql 3.23.54 and UTF-8

Firstly, all the resources under the following manual URL will help:

To answer your specific questions:

1) No. The first MySQL version to support Unicode natively is version
4.1, according to the following manual URL:

However, you can store encoded UTF-8 (not UCS) data in standard MySQL
text/varchar columns.

2) Fetch the data from the table, convert it to UTF-8 using ASP (in PHP
I would use the iconv() functions but not sure in ASP) and update the
row in the table again.

3) See the URL at top of post.


Site Timeline