<div>
<div class="content wysiwyg-content">
Hello. This is my first post here, and I hope I will get my problem solved. I started working on a DB in MSSQL Server (the trial version from MS site). That didn't look bad until I tried to create a DB in Serbian Cyrillic script. For DB, table, sp, view names I used english names, but the data had to be stored in cyrillic and displayed the same way on the asp page.<br />
<br />
I used nvarchar data type which should be ok, in my stored procedures I used COLLATE CYRILLIC_GENERAL_BIN which should also be OK, but when I get something from a form, and send it to the table using a stored procedure (INSERT INTO) I get garbage characters. I tried changing setting many times, deleting the DB and making a new one, but nothing seemed to work.<br />
<br />
Does anybody have any ideas. Please post if you do, I've been agonizing over this problem for a week now. Thank you in advance.<br />

</div>
</div>


Hello. This is my first post here, and I hope I will get my problem solved. I started working on a DB in MSSQL Server (the trial version from MS site). That didn't look bad until I tried to create a DB in Serbian Cyrillic script. For DB, table, sp, view names I used english names, but the data had to be stored in cyrillic and displayed the same way on the asp page.

I used nvarchar data type which should be ok, in my stored procedures I used COLLATE CYRILLIC_GENERAL_BIN which should also be OK, but when I get something from a form, and send it to the table using a stored procedure (INSERT INTO) I get garbage characters. I tried changing setting many times, deleting the DB and making a new one, but nothing seemed to work.

Does anybody have any ideas. Please post if you do, I've been agonizing over this problem for a week now. Thank you in advance.


COLLATE question...

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.