Posted by Jerry Stuckle on 10/21/38 11:53

Peter van Schie wrote:
> Hi Carlone,
>
>> With which encoding data is saved in the DB when data is generated by
>> PHP?
>
>
> Depends on the encoding of the database table or even the column.
>
>> Does it depend to the charset of the php page? And if the string is
>> inserted in a page by the user in a form and then inserted in the
>> database?
>>
>> There is any setting of mysql, or any property of the db, of the table or
>> of the field?
>
>
> Yes, on all of those levels you mention actually. The lowest level is
> column level.
>
> To learn more about character sets in MySQL see:
> http://dev.mysql.com/doc/refman/5.0/en/charset.html
>
> HTH.
> Peter.

Not at all. MySQL stores the data is bytes. It does not change the
encoding at all. All the charset does is affect collation - sorting,
comparisons, etc.

As for PHP - it all depends on what you put in your strings. The string
functions (i.e. strncmp, etc.) are basically latin1. But echo, etc.
will just put out what you tell it.

Maybe explaining the problem you're having would be more help.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

[Back to original message]