Thanks for the reply Raju,

Well I have actually seen this mentioned before (believe me I have spent the week going through all the docuementation and dbforums...painful to say the least) and I have changed all the default locales (I'm sure only the [NT] one needs changing but I changed them all just to be sure) on both the client and server.

I restarted the ASE on the server (which is a japanese OS) and restarted my client app on my English OS but it is still showing me garbage when I view japanese data. And when I add japanese character data from the client it is still going into the sqlserver as '?????'.

I do feel that this should be possible and it must be a client setting. Am I missing something. Please tell if it is so. TeamSybase have been very quiet. Maybe they're pleading the 5th amendment...

Guys??!??!?!?!?!