garbage data stored .....

2002-06-23 Thread toby -



hi guys

im working with some unicode data , store it in mysql db and retrieve it

now its storing the data fine when i use longtext or mediumtext

EXCEPT for a few characters  it gives BOXes fo those characters in the
web-browser

 the boxes suddenly increase their numbr of existance if i change the
encoding in

the web-browser to unicode ( from arabic or auto )


 gives garbage charactes when i check the stored data in mysql prompt .

now i NO mysql supports unicode . well sort of though 
thnx to u guys
it iS storin most part of the unicode which proves this too 

now id be eternally gratefull if someone could pleez help me out with the
rest of storing the unicode 


thnx a million billion in advance 

toby 


_
Chat with friends online, try MSN Messenger: http://messenger.msn.com


-
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




Re: garbage data stored .....

2002-06-23 Thread Roger Baklund

* toby - 
 im working with some unicode data , store it in mysql db and retrieve it
 now its storing the data fine when i use longtext or mediumtext
 EXCEPT for a few characters  

Try using longblob or mediumblob.

-- 
Roger
sql

-
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




garbage data stored ! ! ! !

2002-06-22 Thread toby -



hi guys

im working with some unicode data , store it in mysql db and retrieve it

now its storing the data fine when i use longtext or mediumtext

EXCEPT for a few characters  it gives BOXes fo those characters in the 
web-browser

 the boxes suddenly increase their numbr of existance if i change the 
encoding in

the web-browser to unicode ( from arabic or auto )


 gives garbage charactes when i check the stored data in mysql prompt .

now i NO mysql supports unicode . well sort of though 
thnx to u guys
it iS storin most part of the unicode which proves this too 

now id be eternally gratefull if someone could pleez help me out with the 
rest of storing the unicode 


thnx a million billion in advance 

toby 


_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.


-
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