[How To]Char Name Special Character's Add ?

Page 1 of 2

01/29/2013 08:48 [GM]Nvia#1

Hello Everyone,

Special Characters Character name in SQL Anywhere Just how managers can be made?

Example : [GS]xXx-[(^_~)]

01/29/2013 12:20 TeddyBear94#2

Code:

UPDATE PS_GameData.dbo.Chars
SET CharName= 'NewNameGoesHere'
WHERE CharName= 'OldNameGoesHere'

01/29/2013 21:10 [GM]Nvia#3

Not Work in Game. Only Changes Pvp Rank...

01/29/2013 22:56 Dreameh#4

You have to execute the script that teddy posted and relog if you on the account.

01/30/2013 14:54 [GM]Nvia#5

Daemah you understand me ? :D in my opinion dont understand " DONT WORK " Special Character's . ??GM??? < Special Character Changed. .....

01/30/2013 15:40 TeddyBear94#6

open sql
open a new quiery
copy paste this in

Code:

UPDATE PS_GameData.dbo.Chars
SET CharName= '[GS]xXx-[(^_~)]'
WHERE CharName= 'Nvia'

run that quiery
logg in ur account ( if u was already online logg out and logg again in)
and ur name is changed.

01/30/2013 16:41 [GM]Nvia#7

Picture 1 : [Only registered and activated users can see links. Click Here To Register...]
Picture 2 : [Only registered and activated users can see links. Click Here To Register...]

u Understand ?

It's Work on : [GS]xXx-[(^_~)] but Don't Work my want name ... (tm,<<,>> etc... )

01/30/2013 21:17 TeddyBear94#8

cause these aren't supported from sql.

01/31/2013 09:18 [GM]Nvia#9

How can we support in SQL? and to see a Game?

01/31/2013 21:52 Philipp_#10

You would have to change the data type of the CharName column since VARCHAR does not allow you to store unicode characters.

02/01/2013 10:08 [GM]Nvia#11

thank you for relpy. But What data type should be?

I really grateful to you that you solve my problem ... stay

08/21/2013 20:31 littleJon#12

Design Ps_gamedata dbo chars
change Charname From Varchar to Nvarchar
make sure your client font support unicode (game.exe)
and here you are: [Only registered and activated users can see links. Click Here To Register...]

08/22/2013 01:50 [ADM]SpyRow#13

Quote:

Originally Posted by [GM]Nvia

How can we support in SQL? and to see a Game?

you simply can't

< = lower
> = bigger

SQL use those 2 things as lang as code thats why

if you add > SQL things you want N>vi ( bigger then V )

but who knows maybe i'm wrong o.O

08/22/2013 02:00 nubness#14

[Only registered and activated users can see links. Click Here To Register...]

All you have to do is change the data type from varchar to nvarchar. Make sure it's written like this nvarchar(50). Change your names from the database again, and it will work. If it doesn't work, do you mind pasting here whatever name you're failing to see properly in game ?

08/23/2013 08:19 nubness#15

We aren't forgetting anything, the game.exe simply doesn't support your language. You can try Chinese letters too, they will show up as question marks. Try a Vietnamese game.exe, it will definitely work, at least at showing your name properly.

Page 1 of 2