Re[3]: characters supported in MySQL fields

2001-07-08 Thread Michael Collins
At 11:46 AM +0200 7/8/01, Werner Stuerenburg wrote: >See http://www.mysql.com/doc/S/t/String_syntax.html > >> I thought that the way the data was stored you could not use certain > > characters. Now you have come full circle. This is where I had started and what generated my question. I though

Re[3]: characters supported in MySQL fields

2001-07-08 Thread Werner Stuerenburg
See http://www.mysql.com/doc/S/t/String_syntax.html > I thought that the way the data was stored you could not use certain > characters. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049)

RE: characters supported in MySQL fields

2001-07-07 Thread Don Read
On 07-Jul-01 Michael Collins wrote: > I understand that any ASCII character can be stored within any of the > non-numeric type fields. Does this mean just characters 1-255? > > What happens if I try to import a non-ASCII character, let say, into > a VARCHAR field? Is it discarded or will I sim

Re: characters supported in MySQL fields

2001-07-07 Thread Tonu Samuel
Michael Collins wrote: > I understand that any ASCII character can be stored within any of the > non-numeric type fields. Does this mean just characters 1-255? No, MySQL supports also multibyte character sets used in Asian countries. This means much wider range than 256. > What happens if I

Re[2]: characters supported in MySQL fields

2001-07-07 Thread Michael Collins
At 10:56 PM +0200 7/7/01, Werner Stuerenburg wrote: >Hm. I use php and that has a fuction addslashes which does the >job - it adds slashes for all critical characters. So it >transforms " to \" - is that what you need? I am working with a CGI type application that has recently added MySQL to it

characters supported in MySQL fields

2001-07-07 Thread Michael Collins
I understand that any ASCII character can be stored within any of the non-numeric type fields. Does this mean just characters 1-255? What happens if I try to import a non-ASCII character, let say, into a VARCHAR field? Is it discarded or will I simply not be able to get into a MySQL field in t