RE: [PHP-I18N] storing unicode in mysql database
| From: | Tex Texin | Date: | Mon, 30 Jan 2006 12:11:14 +0000 |
| Subject: | RE: [PHP-I18N] storing unicode in mysql database | ||
| References: | 1 | Groups: | php.i18n |
| Request: | Send a blank email to php-i18n+get-901@lists.php.net to get a copy of this message | ||
When you say the browser charset is set to utf-8, how are you doing that?
If the browser is converting the thai characters to numeric character
references (I assume that is what you mean by html codes: e.g. &#ddddd;
where d is a decimal digit) then most likely the page that is accepting user
data is not set to the right encoding.
Make sure the http protocol specifies the encoding is utf-8 and not iso
8859-1, or if the http protocol is not setting charset, then make sure the
web page is setting it to utf-8 (<meta http-equiv=Content-Type
content="text/html; charset=UTF-8">).
Tex Texin
Internationalization Architect, Yahoo! Inc.
> -----Original Message-----
> From: Naintara [mailto:naintara@vismaya.info]
> Sent: Monday, January 30, 2006 3:32 AM
> To: php-i18n@lists.php.net
> Subject: [PHP-I18N] storing unicode in mysql database
>
>
>
> Hi,
>
> I'd like to know what would be the best way to store Unicode
> text in a database. I am using MySQL 4.1. I am trying to
> create a multi-lingual CMS and the browser charset is set to
> utf-8 and the database and tables are set to UTF8 and
> utf8_bin for charset and collation.
>
> While displaying in the browser, Thai text is displayed
> correctly but it is stored as html code in the database. Is
> this correct behaviour or is there a better way? Would I need
> to specify charset for every query, or is it enough to have
> specified it for the mysql connection, results and client
> charset options.
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 267.14.23/243 - Release
> Date: 27-Jan-06
>
>
> --
> PHP Unicode & I18N Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>