on 01/13/2003 1:58 PM, Paul DuBois at [EMAIL PROTECTED] wrote: > How do you know this isn't simply a failure of your terminal window > to display the character properly? That's the most likely problem > here, not that your data are stored incorrectly.
Well, I don¹t for certain, I just did a dump to a text file and here were the results... As you can see the pesky Æ is in place of the ®, which really makes no sense to me, as in a browser is displays as a ®, but if I do a string replace on the ® it does not see it as one, so it wont replace it with the html entity I desire, this also happens on a few other characters as well. -- -- Dumping data for table 'custom_bikes' -- INSERT INTO custom_bikes VALUES (5,'2002 FAT BOYÆ, FLSTF -','Custom Black Powder','$23,152 plus','Custom Black Powder Coating on Accessories\r\nCustom Wheels\r\nExhaust/Hi-Flow\r\nCustom Pegs and Footboards',1,'1','qmKjwFN4eobgxQyCiQZ5u7mm.jpg',20030112182536,200301121538 31); INSERT INTO custom_bikes VALUES (3,'2002 V-RODÆ, VRSCA -','Skull paint','$23,397 plus','Custom Skull Paint\r\nHi-Flow/Pipes\r\nCustom Pegs and Grips',7,'1','5cFX4x85HAe2Fao2pGQUSAyp.jpg',20030112183701,20030112153742); INSERT INTO custom_bikes VALUES (4,'2002 ROAD KINGÆ FLHR -','Flame paint','$23,809 plus','Custom Luxury Rich Red with Red Flames paint\r\nPerformance Exhaust/Hi-Flow\r\nSecurity System\r\nCustom handgrips, footboards, and other accessories',6,'1','Y5Es935New44GzuUnTxJFA3i.jpg',20030112175803,20030112153 750); INSERT INTO custom_bikes VALUES (6,'2002 FAT BOYÆ, FLSTF -','Silver with blue flames','$22,497 plus','Custom Silver and Blue Flame Paint\r\nPipes/Hi-Flow\r\nCustom Grips, Pegs, and Footboards',4,'1','RXofzWGeVbc14G4EDbAwrQw3.jpg',20030112175757,200301121538 41); INSERT INTO custom_bikes VALUES (8,'2002 FAT BOYÆ, FLSTFI -','White pearl with white flames','$31,274 plus','Custom White Paint With White Flames\r\nFull Chrome Accessory Package\r\nCustom Wheels\r\nPerformance Exhaust/Hi-Flow',5,'1','X5m5YtfFuGoLDuT5MJ9YYjuh.jpg',20030112175800,2003011 2153901); INSERT INTO custom_bikes VALUES (9,'2002 DYNA WIDE GLIDEÆ, FXDWG -','Skull paint','$26,952 plus','Custom Skull Paint\r\nCustom Wheels\r\nTriple Trees\r\nLots of Chrome\r\nPerformance Exhaust/Hi-Flow',3,'1','7uG5VXUfgiwfgwN4Xg4jpR6P.jpg',20030112182532,2003011 2153907); INSERT INTO custom_bikes VALUES (10,'2002 SOFTAILÆ DEUCE, FXSTDI -','Flame paint','$34,619 plus','Custom Flame Paint\r\nCustom Wheels\r\nChrome Accessory Package\r\n95î Big Bore\r\nExhaust/Hi-Flow',2,'1','GrjGCz33woRHwe9JH9xyWZ7j.jpg',20030113050601 ,20030112153914); INSERT INTO custom_bikes VALUES (14,'2002 V-RODÆ, VRSCA','Flame Paint','$22,817 plus ttl','Custom Flame Paint\r\nHi-Flow/Pipes\r\n',8,'1','HpcfDW5BmkoozLVWDYQA63bX.jpg',20030113065 241,20030113065241); INSERT INTO custom_bikes VALUES (15,'2002 FAT BOYÆ FLSTFI','Snakeskin Paint','SOLD','Custom Snakeskin Paint\r\nScreaminí Eagle Exhaust/Hiflow\r\n',9,'1','GuCeu6qbwzysXg2QxmFrWvoW.jpg',20030113065405,2003 0113065405); INSERT INTO custom_bikes VALUES (16,'2002 SOFTAILÆ STANDARD, FXST','Flamepaint','SOLD','Custom Flame Paint\r\nLots of Chrome\r\nCustom Accessories\r\nSecurity System\r\nVance and Hines Exhaust',10,'1','6grjaxN7LKcUtNneMAsoMvB4.jpg',20030113065514,20030113065514 ); sql,query,queries,smallint ------------------------------------------------------------- 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
