SQL Restore Error

[Kreain]

any help when i try doing GameDB restore

 

[Mahi]

LINK -> Thesnowman guide -> there's something about SQL2005 - just read it ;-).

 

[Kreain]

Umm Special person, I Followed That Guide >> I Said Its When Im Restoring It Special person Read For Once

 

[snaity]

no fix, u is using windows vista? i got that too but on windows vista.

Only fix use Windows XP or 2003.

 

[Kreain]

im using XP look at my skin, im using XP stripped.

 

[Kreain]

any help? can someone open mssql manager and right click GameDB > Tasks > Back Up, and upload it please D:

 

[cypher]

I should have watched my mouth and not said/talked poop to DeadlyData telling him things like your are not welcome here because then I become the one who is truly not welcome here.

 

[Kreain]

*bump*

 

[clever]

at your SS, i think theirs is a conflict on your SQL

try find out

 

[chumpywumpy]

Clue in the error:

"The code page 936 is not supported by the server"

If you did your *nix setup right you should remember that you had to include an odbc var to your bash profile to enable codepage 936 when talking to the sql server as the database is in Chinese.

I guess that you didn't add the east asian language pack to the regional and language options in your control panel (maybe you did it after installing mssql and it doesn't know?) but your server definitely does not support Chinese properly and so cannot restore the db. He no speekee

 

[Kreain]

I got the language packs
any help with the other part like odbc you said ?

 

[chumpywumpy]

go go /home/cabal and open .bash_profile and add the following line next to the other exports (or at the bottom):

export FREETDS_UNIXODBC_CHARSET='cp936'

I did this in my Cabal profile as well as my normal user (i use this linux box for other things too).

That bit is only on the linux side though and won't fix the problem with restoring the database. I had lots of east asian language packs installed (Korean, Japanese and Chinese mainly) way before i installed the sql server (2005 express), and i have them all ticked on the Advanced tab of my regional and language settings (in control panel) too which might be the difference. it may be that the server picks up supported languages when it is installed as i didn't change any language settings in sql. The databases themselves are stored with a Chinese_PRC_CI_AS collation so your sql server must be able to accept that language or the import will fail.

 

[Kreain]

again *bump*

 

[Kreain]

*bump*