Dear All,
Is there any feature in SQL Server 2000 through which I can translate my Database into different languages at runtime.
Thanks & Regards
Anoop Singhal
Oracle Certified Professional
Team Leader (Database)
KeyWest Business Systems (P) Ltd.
Ph. 0135-2710533,2710511
Cell: +91-9412051028
Could anyone provide me an example of the effective way of design a database support multiple languages. Currently I working to design a database for travel website which support 3 different languages, and more languages will be added in in the future. One of my friend advice me to put different languages into the same table for example
Table Hotel
ID
Description_EN
Description_ES
Description_FR
Location_EN
Location_ES
Location_FR
....
But I don't thing it's a good idea to do so since in the future if I would like to add more languages I have to modify the table and I have to replace all of the sql statements. I am seeking for the best solution , could anyone help.
Thank you very much
Dear
Since my other threads concerning my question weren't clearly answered to me I'm starting again:
I want to store musclegroups,musclecategories and muscles in different languages, please have a look at the proposal below and tell me if I'm on the right way
Hello
I have 3 related tables: MuscleGroup, MuscleCategory, Muscle.
For all those tables I want the name and description in multiple languages.
Therefor I need your best suggestions storing multiple language columns in sql or even better a standard way for multiple language storage.
Thank you
P.S. I started that question/thread several times (sometimes even with diagram pics) but I never received a very clear instruction or standard.
Hi
I want to show my reports in different language . For this i have added a parameter Language on the report that contain all the language . Now i want to change all the captions of Report and parameter list in selected language .
How i will do it ?
@mit
We should support multiple language(Latin,chinese,japanese,korea) in one report when exporting to PDF format in reporting service. We have used Arial Unicode as our font. But when we exported the report, the korean language item can not be displayed. Any idea on that? Thanks a lot.
View 3 Replies View Relatedi using sql server Express, i want to change the default language from US-English to British EnglishWhere and How?
HI,
I am using Multi languages web application with sql database...I am using Arabaic and English languge is there is any thing to change sql database data in Arabic and English on run time.I am using only one database client add some record in Arabic in sql database but the another side some one wana check those records in English...plz let me know how can i do on run time asp.net
Thanks with best regards,
Hi i use sql server 2000 and i found problem in my database that is
when i write arabic language and closing my table and open it again i found all my data like question mark.
what can i do to save my data with arabic language.
note i use windows 2000 server.
HI
I have sql database. now i want to connect to this server and get the data. Please let me know how to initiate the server and get the data.
Earlier the program is using MS access database and code is like below.
CDaoDatabase* pDB = NULL;
pDB = new CDaoDatabase;
char query[256], *name;
try
{
// Force usage of latest DAO engine
AfxGetModuleState()->m_dwVersion = 0x0601;
AfxDaoInit();
char *dbPath = new char[strlen(envVar) + 40];
sprintf(dbPath, "%s\MilkDB.mdb",envVar );
pDB->Open(dbPath);
}
now i am using sql server as database size was increased a lot. So please let me know how to initiate sqlserver from C program.
Thanks in advance.
Thanks
venkat
I have generated a database for my website, I intend on using software that will convert the database into static web pages.
Big problem I have I am not a programmer, but I know a tiny bit about tags etc. for search engines.
The meta tag description is what I want to create using a field in this database.
The software I am about to use has a sql builder is there anyway it could be done be highlighting the relavent field and using sql language.
PLEASE someone Help
This problem has been driving me around the twist.
hi, friends i need a help in design a database throug c language
i will be very thanks if i get replay
I have ran into a problem making a database where i have two versions of a book , one in russian and the other in English. The english part worked but when i input the data for Russian it gets replaced each time with question marks. Is there something i have to enable for the SQL database for it to be able to store Russian Text, or is it a DataType i have to set???
THANKS IN ADVANCE
HI guys!
I have a Japanese sql server installed in one server..
I want to transfer everything to an English SQL Server version.
Will this be no problem?
Hope you can enlighten me on this one...
Thanks!
I have a database called 'objects' with one of its fields called 'Image' (data type is set to image) and a file in my desk top labelled as 'Pictures' (this is where all my pictures are keep). At run time i want to be able to select and add (upload) my preferred picture to the image filed of different records. Could you please advice me what i should do?
View 9 Replies View RelatedI have Sql server 2008 database with 200 GB in production.But It will not support multilanguage Since all the tables and procs is having varchar datatype.
I need to change the Entire Tables and procs to support Multilanguage(nvarchar,ntext) .
I have Many Huge data tables with numerous index .ALso I could not afford too much down Time. How can I perform.
Hi,
I'm trying to create a database that takes specific information from a number of databases on different servers to make some reporting that we have much easier.
I'm pretty new to SQL so I'm not sure of the best way to proceed. I read an article that suggested I use the OPENROWSET command. The problem is, the version of SQL that came with one of the programmes we use is limited and will not allow you to turn on the allow "Ad Hoc distributed Queries" so the SLQ statement will not execute.
I'm confused why it won't let me to connect through ODBC as I've created a web page that selects data from this database with no problems!
Here is the SQL statement that I've written to make sure it is the correct one (on the msdn library page it said that this was the ODBC connection):
SELECT a.*
FROM OPENROWSET('MSDASQL','DRIVER=(SQL Server);SERVER=APPOLOACT7;UID=sa;PWD=***************',
'SELECT * FROM MDCTestAndDev.dbo.TBL_CONTACT') AS a
I've also created the ODBC connection using the tool on Administration Tools>Data Sources ODBC
Any help would be greatly appreciated (also any ways of selecting from one database and inserting it into another will be helpfull)
Thanks
Using SQL Server Express 2005, I have two databases. AppDB - The main application database.GeoDB - A somewhat static ZIP code / states / other geographic stuff databaseI need to have some foreign key columns in tables in AppDB reference columns in the GeoDB database tables. Eventually other application database besides AppDB will be doing the same thing in our infrastructure. After googling and reading for days, here is what I
think I know:You cannot create foreign keys that reference tables in another database in SQL Server.You
cannot create foreign keys that reference columns in a view, and you definitely cannot make an index on a view that has base tables in another database.You can create a trigger that references tables in another database, but this can be flaky? (nested/recursive trigger problem).SQLServer
2005 supports multiple schemas within the same database. Maybe I should logically separate my databases this way? Seems like it would be a tough solution to manage since I already have some databases live in production that will eventually use this 'static' GeoDB. Also, seems like it
wouldn't be as portable as keeping the GeoDB info in its own database,
but maybe I'm being too software engineer-ish here - afraid of low
cohesion, high coupling.I will greatly appreciate any advice I can get, or any more options I am missing. Thanks,Adam Nofsingerucnmedia.com
Hi All,
I am designing database where few of the master tables will reside in different database or in case different server. Scenario is
Server "A" with Database "A" may host the "Accounts" table.
Server "B" with Database "B" may host the "Product" table.
I am designing database "Project" which will hosted in Server "A".
My application requires this master tables [readonly access] as data inserted in my application refers this tables. Also there are reports to be generated which refer this tables.
How do i design my database and sql queries?
I am thinking of approach of having equivalent tables created in my database and writing service which keep tables in my database in sync. This will ensure good perfomance during transaction and reports as they will need to refer this table locally as opposed to different database or different server.
Any thoughts on above approach?? or any better/standard way for such scenarios ?
Thanks in Advance. Your inputs will be of great help.
Hello:
My client has a db with the following structure:
Online US Searchable Map of the 50 US States. Users search criteria is the following: Query records by selecting state, county, then record. Each County table has 10-20 tables. All databases combined = 500MB and TLogs = 100MB.
How would you re-design a relational DB where users could query data by state-county-record. Currenty the DB's are created by the County of each state which creates hundreds of DB's in SQLServer with no realtionship to each US state. What would be the best design to ensure good performance, data integrity and maintenance? Would you create 1 DB with all 50 states, create 4 DB's and divide by region(N,S,E,W), 50 DB's of each state or leave it as is with each county it's on DB? Any suggestions would be appreciated.
thx
rob
Hi folks;
I have just realised that my language problem is because DB language; then I've changed the language to Turkish but it didn't effect tables.. When I wanted to change tables manually it worned data loss may occur..
What would you suggest to do it?
Thanks
Hi
I am using SQL server 2000 as backupend...
Pls suggest which language is used as frontend...
(web)
thanks
asm
i am went Language arbic fram windows xp media center edition 2005 modil number 1252736 please
..............................tomorrow
Hi;
I need Turkish characters in my DB therefore I have to change Collation from SQL_Latin1_General_CP1_CI_AS to Turkish
But what I realised is that aspnet membership tables' collation is SQL_Latin1_General_CP1_CI_AS as well and they can store Turkish chars but why not my tables?
Thanks..
I want to insert data into my database in greek language but i am getting some "???????" symbols. I have a table called "Words" with columns "Word"-as char and "Result"-as int. Can somebody please explain me what to do?
Thanks, Mike
I am looking into a production geared software called MassGroup. (www.massgroup.com) It says that its FactoryServer builds are on a standardized SQL framework and web architecture for data collection, work order requests, reporting and asset management. My questions are:
1. Is SQL its own programming language? If not what is it?
Answer: After going thru several pages and reading the fine print I discovered they use VB, ASP, COM technology, and Crystal Reports.
2. How powerful do you think this would be at gathering data and does it have the capability of creating a number sequence automatically? (example: 0001; 0002; 0003...)
Any help would be appreciated.
Thank you in advance!!!!!
Good morning. I have an interesting scenario where one of the requirements of the application is to translate an application to different languages. Modelling the system to translate the UI went over without a hitch, however, we have now been told that the application will need to translate all the existing database tables. Has anyone ever had to do anything like this?
I was curious if anyone out there has any suggestions on how to approach this issue... ways in which it could be modeled, alternative approaches, anything at all would be appreciated. Many thanks in advance!
Does anyone here know anything about the DCS Scripting Language.
A contract vacancy has arisen using this language but I've never heard of it and there does seem to be anything on the internet about it. Can anyone help?
Just curiosity ... never pick up this since beginning. Our box is setted the language to English (United States) while the local machine setted as English (Australia) which I thought it's corresponding to locale machine not sql box.
Will this language setting effecting date issue stuff (DD-MM-YYYY)? Can someone clarify on this?
This thing brought up my attention cause we've just ran a trace and there is a warning which is:
User Error Message - Changed language setting to us_english.
Thank you.
Hi all,
i need to store russian data in sql server db but i found the russain data appeared as odd character in the table, can sql server support it or is there other solution for it? thanks!
How could i do if i need to use another language, unavailabel in collation such as laos, burma ?
View 2 Replies View Related
hey all
I am using Reporting Services 2005 and Microsoft Updates has been run on my machine.
All my reports were set on the above =User!Language and my regional settings to NZ - others to US etc and they
all worked fine until today!
If Sql P2 was run has anyone else struck this? and do you think this is the cause? the other updates were mainly XP.
Anyone have any ideas of what I can do now?
thanks
Dianne
i need to know in which language the standard SQL is implemented.. and that from where can i get the code.. i need the code for the "logical operators" of SQL.
Plz help..