COLLATE question...

Posted on 2003-03-03
Medium Priority
Last Modified: 2008-02-01
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.
Question by:SLK
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment

Accepted Solution

naca earned 300 total points
ID: 8089887
Your problem is this:

<%Session.Codepage = 1251%>

Stuff being sent from your pade is corrupted, this will fix it.

naca ;)

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question