Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 18th, 2006, 04:59 PM
Registered User
 
Join Date: Nov 2005
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Macedonian Language in SQL database

I am writing code in VB.NET 2005, my database is SQL Server 2000. I what to wright data in SQL tables using Macedonian Language, when I use this Language I have ???? question mark in table cells. I already have install Macedonian Language in my WIN XP


 
Old April 20th, 2006, 09:36 AM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Have you set the language appropriately in SQL Server? It doesn't matter what you have your client set to, you need to tell SQL Server which language.

SET LANGUAGE language
GO

For example:

SET LANGUAGE Italian
GO


 
Old April 20th, 2006, 09:46 AM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Actually, you may have to uninstall and reinstall SQL Server and install it using the correct language. Look in BOL about using different languages. I don't think you'll be able to change it on the fly.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi Language Database nabeelalkaff BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 1 December 26th, 2007 02:41 AM
importing and exporting database in multi-language lenseere General .NET 0 November 29th, 2007 04:47 PM
SQL Server -French Language prabhakaran SQL Server 2000 3 December 14th, 2006 03:13 PM
SQL Language khng SQL Language 3 November 22nd, 2004 08:22 PM
How to write in SQL language for auto running numb Jane SQL Language 1 November 22nd, 2003 12:37 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.