Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
djseng
Starting Member
25 Posts |
 Posted - 2005-02-03 : 06:15:09
|
| I'm working on a naming convention for usernames. My userbase is international and some users have accents, etc. in their names. I was wondering, would it not be a good idea to include these characters in their usernames? If not, does anyone have a good method for casting (best word that comes to mind) characters with accents to their base character? For example: ö -> oCurrent logic asks the user to login via their username, but the username is not a PK or anything.The best argument I can come up with, is that if the user doesn't have a keyboard with the keys they require to make the accented character, it won't exactly be user friendly for them.-Dave |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-03 : 06:19:46
|
i'd use ordinary chars. keep the char loose the accent. ö->o, á->a etc...Go with the flow & have fun! Else fight the flow  |
 |
|
|
djseng
Starting Member
25 Posts |
Posted - 2005-02-03 : 06:25:37
|
| Yeah, I agree, I'm scrounging the 'net right now figure out how to convert these accented characters to their base character(preferably in sql).If anyone has done this in the past, input would be highly appreciated. Is there any better way to describe what I want to do besides 'downcasting' the accented character to its base character? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-02-03 : 08:05:06
|
| select 'öá' collate Greek_CI_AI--orselect 'öá' collate Ukrainian_CI_AIwhy greek or Ukrainian? because it doesn't have those chars.Go with the flow & have fun! Else fight the flow |
|
|
|
djseng
Starting Member
25 Posts |
Posted - 2005-02-07 : 03:03:10
|
| Thannks man!That's hecka cool! |
|
|
|
|
|
|
Usernames (International)