RE: Regarding storing non-english chars in mysql

2010-01-19 Thread Jerry Schwartz
Another tidbit about this: Windows-based browsers apparently translate between CP-1252 and UTF-8 automatically. This generally doesn't cause trouble, but it cost me a lot of sweat and tears to figure out. I never looked to see what *nix-based browsers do, I ran out of time and energy. Regards

Re: Regarding storing non-english chars in mysql

2010-01-19 Thread fsb
On 1/19/10 2:19 AM, "Ningappa Koneri" wrote: > 3.It worked even after removing tag from the head tag as well <-- plz > through some light y it got displayed at the browser ? this is not a mysql question. but see: http://www.w3.org/TR/1999/REC-html401-19991224/charset.html#h-5.2.2 the likelih

RE: Regarding storing non-english chars in mysql

2010-01-18 Thread Ningappa Koneri
style | www.comviva.com -Original Message- From: fsb [mailto:f...@thefsb.org] Sent: Tuesday, January 19, 2010 2:35 AM To: Ningappa Koneri; mysql@lists.mysql.com Subject: Re: Regarding storing non-english chars in mysql you can specify the character encoding (called CHARSET in mysql) and co

Re: Regarding storing non-english chars in mysql

2010-01-18 Thread fsb
you can specify the character encoding (called CHARSET in mysql) and collation on a per column, per table or per database level. e.g. CREATE DATABASE foo CHARACTER SET utf8 COLLATE utf8_general_ci; or CREATE TABLE foo ( ... ) CHARACTER SET utf8 COLLATE utf8_general_ci; or CREATE TABLE foo ( ba

RE: Regarding storing non-english chars in mysql

2010-01-18 Thread Gavin Towey
http://dev.mysql.com/doc/refman/5.0/en/charset.html -Original Message- From: Ningappa Koneri [mailto:ningappa.kon...@comviva.com] Sent: Sunday, January 17, 2010 11:32 PM To: mysql@lists.mysql.com Subject: Regarding storing non-english chars in mysql Dear all, I have a problem in migrati