Re: porting MS SQL to mySQL

2002-12-12 Thread 'Bob Diss'
Here's some info that might help: nvarchar = MS$ variable character string, up to 4000 characters, stored as UNICODE UCS-2. AFAIK, MySQL doesn't (yet) support UNICODE directly. However, M$ SQL often forces the nvarchar/ntext types on by default. So, if you don't need UNICODE, use varchar. If you

porting MS SQL to mySQL

2002-12-12 Thread Tom Coffin
Hi all- I need to know what the mySQL equivalents are to the following MS SQL datatypes: nvarchar smallint bit int ntext real datetime float money smalldatetime numeric decimal Thanks for your help! Tom - Improve your reimbursement rate and lower your risk for audit. The MMI Coding Hotline