i'm using Visual Studio 2010(c#) for a winapp i'm writing.
i have a DataBase in which i have 6 tables and there are so many fields in them that use unicode characters( Persian) and all of them are nvarchar(n) type cuz i had problem with text earlier, but when i want to search in them every thing works fine but one letter ( the equivalent for Y in Persian and Arabic which is 2 characters) but the search queries recognize neither of them in some fields and in some other only the Arabic letter but my language is Persian and it's kinda messed up. and not forget to say that i only have this problem when i use direct commands on DB, but when i use a data set or data table there is no problem like that. where can i access the options for unicode and such in sql? thanks to those who answer. my work has come to a dead lock.
Jump to Post
When you work on a DataSet or DataTable you are using native .Net types and the strings are unicode which is why your searches work.
When you construct your commands in SQL do your build the command string manually in code or do you use SqlParameters to load the …
All 3 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.