I have been using MySQL for some ti

[idover]

I have been using MySQL for some time now and have been very happy with its performance ( and cost - free! )... but my most recent app ( web app, but will soon convert to COM model ) requires something more speedy... so i decided to switch to MSSQL, with practically no background with it

the biggest problem that i am facing is that the data within the database is in both english and spanish, with portuguese coming soon... the international characters are giving me a fit...

within MySQL, a and á were treated as the same character, as well as all of the other international characters and their most basic counterparts... this worked beautifully for my app... but now, with MSSQL this is not the case at all... a and á are completely different from one another...

hopefully, someone will understand my problem... i am a bit familiar with Enterprise Manager... is there a way to tell the SQL Server to treat these characters as the same alphabetically, but display them properly?...

Thanks in advance!...

 

[idover]

okay... figured it out... mssql uses collations for character sets... i set the columns to whatever they should be... traditional spanish, dictionary sort in my case... but is there a general ( very general ) collation that could be used that includes all latin based languages?...

 

[fluteplr]

there is a iso_latin collation but I have never used it so I can't tell if it would solve your problem.

 

[idover]

thanks, fluteplr... i assume that means 'flute player', which is cool!... i'm a musician myself... but i couldn't find the iso_latin collation...

 

[DougP]

Can you both say unicode???? DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive