Foreign alphabet support & ASP / email

[AlShack]

Hi all

I need to create an ASP form that will allow global users enter information in their native language (& alphabet), and then email that information using CDO.

I also need to store the inforamtion in a SQL database, so I could either use the database as the source for the email or the ASP form, don't mind either way.

I've done a simple test and it appears that Norwegian-type characters are ok, but Chinese/Russian are not. The Norwegian characters are stored in the database as they appear on the screen, but the Russian/Chinese are not (they are stored like this мат&#1077).

Any tips or clues as to how I could achieve what I need to?

Many thanks
Alan

[paulredpath]

Alan,

They will all need different character sets, and in an sql db you can only store latin or say chinese etc to the best of my knowledge.

If you can find any way of doing this please let us know and we can try any workarounds.

[WhiskyFudge]

Since SQL 2000 you've been able to change the character set an individual database/table/column uses from the property field 'Collation'. (Previously it was server wide only!) Looking at what's available on cat2's installation of MS SQL 2005 you should be covered to do what you want. However I'm sure Paul will be willing to add additional character set's should it be required.

I know this will work as I did a project that still sits on Cat2's servers that supports multiple languages. Once you set the database properties correct the rest is pretty much plain sailing as far as I can remember.

I do however sense that this will mean you'll have to have a different column for every character set you wish to support which isn't all that idea. So if anyone has any better ideas I'm all ears.

HTH

Jas