Was working on a database job last night, and ran into a little stumbling block, hope all this comes though in email, if you see a � it is a "registered mark" just in case the email clients out there change it around.
So I have a simple database, one table, and say one field, varchar(14) and in it I put hello�, I use html input form elements and a middleware called WebSiphon, I have also done this in php with phpmyadmin as well, the character shows up on display in the Browser as a "registered mark", as well as in phpmyadmin, all good so far. Now, in my shell in the mysql prompt, or on a dump of the data, the "registered mark" is not what it should be, here is a example. mysql> select name from custom_bikes; +--------------------------------+ | name | +--------------------------------+ | 2002 FAT BOY�, FLSTF - | | 2002 V-ROD�, VRSCA - | | 2002 ROAD KING� FLHR - | | 2002 FAT BOY�, FLSTF - | | 2002 FAT BOY�, FLSTFI - | | 2002 DYNA WIDE GLIDE�, FXDWG - | | 2002 SOFTAIL� DEUCE, FXSTDI - | | 2002 V-ROD�, VRSCA | | 2002 FAT BOY� FLSTFI | | 2002 SOFTAIL� STANDARD, FXST | +--------------------------------+ Where the � should be a � So in my middleware, I have made a function called encodeHTML(string) And of course it does not work to convert the � to ® for propper html display in a browser. Granted, most browsers are forgiving, but I consider this muddy data in MySql and would like the correct data in there. Thanks for any help. ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. --------------------------------------------------------------------- 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
