|
|
Posted by Jerry Stuckle on 07/02/06 19:38
howachen@gmail.com wrote:
> Hi,
>
> I created a table using :
>
> ----------------------------------------------------------------------------
> CREATE TABLE test(
> unicodeText VARCHAR(45) NOT NULL
> )
> CHARACTER SET utf8 COLLATE utf8_general_ci;
> -----------------------------------------------------------------------------
>
> in php, when i need to query for the data, i need to set the character
> set per each connection, i.e.
>
> $DB->query("SET NAMES 'utf8'");
>
> however, i expect this is a kind of overhead ? (a roundtrip delay per
> connection)
>
> how to perform this automatically?
>
> I tried to set "default-character-set=utf8 " in my.ini but this didn't
> help...
>
> thanks.
>
You could try a MySQL usenet group - like comp.databases.mysql.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|