|
|
Posted by Erland Sommarskog on 05/25/05 23:03
laurenq uantrell (laurenquantrell@hotmail.com) writes:
> That's only one of the problems! I want to store the data with the
> international characters but then I need to strip out the international
> characters for certain output, such as in e-mail addresses...
I would recomment that you store the e-mail address. While the e-mail
address often can be formed as firstname.lastname@domain.xxx, this is
not a requirement.
And the local transformation may not be the one you expect. äöü in German
after often replaced with ae, oe and ue. (Whether this is actually common
in mail addresses, I don't know.)
If you are thinking of the comment part of the e-mail address:
John Smith <johnsmith@example.com>
(John Smith is the comment here) You should either encode the comment
according to MIME as per RFC2047, or send as-is. But don't misspell
people's names.
(By the way, permit me to point out that the term "international characters"
is a misnomer. The internationalest characters I can think of is the
English alphabet A-Z. Non-ASCII characters is a better term, and
technically precise.)
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|