There are probably several changes to be made...
1- store characters in 'binary' fields and not text or char fields;
2- convert them into html entities before sending to the client (e.g. à is
converted to à). most languages can do it easily;
3- include charset as outlined previously, possibly adding the language
extension as suggested (fr) in order to make it even more friendly to your
users.
Regards
Jose Carlos
>i doubled checked things, the problem is in the database server
>french characters are not accepted as is, my sql converts them to , or ?....
>any solution for this??
>
>
>At 14:06 22/04/01 +0300, you wrote:
>>In order to see french characters you have to put in your php4/html page
>>header the line:
>><META http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
>>
>>Put this line in all your pages that writing or reading from mysql server.
>>
>>I'm not sure about iso code - try to find your language code...
>>
>>Original massege:
>>
>>--------------------------
>>hi,
>>i'm running mysql server version 3.23.33 on a win98 machine
>>using the following characterset : latin1
>>i have the following problem
>>when i enter french characters like à or é... into the database using php4
>>scripts they are improperly recorded and returned like ? or ,
>>
>>what i want to know is what's the reason for this? bad character set? (in
>>which reason how to change it and which one to choose?)
>>is ¨PHP responsible for this?
>>
>>
>>
>>
>>--Tamar Klein
>>
>>---------------------------------------------------------------------
>>Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail
>><[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
