gdarling wrote:Hi Greg,
As best I can tell, "€" is not defined in WE8DEC .. http://www.columbia.edu/kermit/dec-mcs.html
You'll want to use a database characterset that can support the characters you actually need to store.
Generally AL32UTF8 is recommended these days as it supports a huge number of languages and characters, but if you want to stick to a single byte characterset for some reason, WE8MSWIN1252 is frequently used as well.
You may be able to figure out some sort of hack to be able to put the character in and get it back out looking the same, but unless the middle part (ie, the storage in the database) is correct and valid, all bets are off and you're just asking for trouble.