DB Design :: DataType Change In Databases To Support Multi-language
Sep 13, 2015
i need to change the production database structures with multi language Support , datatype from VARCHAR to NVARCHAR in all SQL Objects SQL Objects: Tables, Functions, Stored Procedures...Some of production Tables with 15 Croces records with 10 indexes.how to change the entire databases through SQL scripting
I 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.
I am trying to execute a query which has the Greek letter as below. But it is not returning any rows even though I have a row exists in database matching the condition below.
select ID from pmf where portfolio = 'ãç1'
I am using the ODBC connection to execute the query.
Hi, This is chirag patel. we are going to develop web application which can disply data (Search Results) in different language. if user selected country Japan, then search results should be in Japanese. if user selected country Chian, then search results should be in Chinese. now i want to store all these read only data in Database. how and where i can store it? do i need to have different Databases? or with single database also i can achive? I means what is advisable approach to achieve this?
if Single Database for all countries then how i can store same data in different languages in single table?
please guide me if anyone know how to achive such kind of scenario in SQL Server?
i wanted my database to support hindi language. how will i implement that? i mean i don't see the hindi_bin for the collation options. do i have to install extra unicode support for the hindi language? or is there anyother way i could implement that?
Hi,I have a database and want to store data in Spanish and English. Toaccompish this:1. Do i need to create separate tables for both the languages likeitems_en and items_sp?2. If I opt for the UTF16 charset what single collation setting can Iuse?Thanks and RegardsJackal Hunt
I need help about storing data in chinese, arabic, english..... languages in one database. For that I create Database with Latin1_General_CI_AS and I have table Testing with two columns wich are LangName= nvarchar(50), and Comment = nvarchar(MAX). I tried to store comment in chinese language but I could not, when I entered the data "個編碼å?¯ä»¥åŒ…å?«è¶³å¤ çš„å—元:例如,單單æ?å·žå…±å?Œé«”就需è¦?好幾種ä¸?å?Œçš„編碼來包括所有的語言。å?³ä½¿æ˜¯å–®ä¸€ç¨®èªžè¨€ï¼Œä¾‹å¦‚英語,也沒有" it converted as ? sometimes or look as a square.
Hi,I have a table in an MS SQL 2000 database that represents fields on a form.CREATE TABLE [dbo].[TagData]( [FieldName] [nvarchar](255), [UserID] [int] NOT NULL, [Data] [nvarchar](255)) A requirement has come up where some of these fields must contain Hebrew, or any other unicode character, data and some of the fields will be English. How can I go about saving and retrieving this information.The current solution is a legacy Classic ASP application and I suspect I am going to have to redo this in ASP.NetThanks,Leon
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
Dose SQL Server Integration Service support Farsi (Persian) language?
I passed a column of a Farsi text database to Term Extraction component put it didn't send anything to output (destination).
I even use CodePageConvert (http://www.microsoft.com/downloads/details.aspx?FamilyID=9E56417E-23D1-4FD3-8D6D-61314FAA2DE3&displaylang=en) between Source and Term Extraction, it seems that it converted the text but still nothing comes from the Term Extraction.
I've made my Cube having two language support - Japanese and English. For that I'm keeping two description columns relavent to language and mapping in dimenstion attribute translation. Till that it is fine. In SQL 2005 Analysis Services Browser it working very fine. But when I use this cube with SSRS, I've made Custom parameter for Language. And based on that I'm chaning Report.Language property for the selected language. It is working fine in case of Report Data. It is converting data in Japanese when I select Japanese Language and translating in English when I select English. But Problem is that Parameter's data is not chaning when I change the language. I supposed to that when I'm changing Report.Language to Japanese then Parameter's data should be changed in Japanese. Please help how it can be possible.
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???
I've made my Cube having two language support - Japanese and English. For that I'm keeping two description columns relavent to language and mapping in dimenstion attribute translation. Till that it is fine. In SQL 2005 Analysis Services Browser it working very fine. But when I use this cube with SSRS, I've made Custom parameter for Language. And based on that I'm chaning Report.Language property for the selected language. It is working fine in case of Report Data. It is converting data in Japanese when I select Japanese Language and translating in English when I select English. But Problem is that Parameter's data is not chaning when I change the language. I supposed to that when I'm changing Report.Language to Japanese then Parameter's data should be changed in Japanese. Please help how it can be possible.
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.
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
I'm using the ReportViewer to display reports in ASP.NET pages. The reports include dates that must be shown in its long format, but in spanish. Now, everything I'm working with is in english: my workstation and server OS, SQL Server 2005 and client browsers (I'm testing with IE and Firefox). I'm using FormatDateTime() to show dates, and I tried to change the UI culture to es-MX in web.config with no success. I'm also getting short dates as mm/dd/yyyy, but I need them as dd/mm/yyyy.
Please, any ideas are welcome, and, the more the better. Tks!
I'm running SQL Server 2005 Express SP1 on a Danish PC, and I need to have the server language set to Danish.
However, when I want to change the language in server properties (the current language is English (US) using Management Studio Express, I can't - all of the properties on the General page are greyed out.
I know that the SQL Server Express SP1 download is available in several languages (Danish not being one of them) - does that mean that I can't get my SQL Server Express SP1 installation to "speak" Danish at all?
I have a question regarding a Language property on Report, Table and Cell levels. My reports must show monetary values in different formats depending on a currency symbol where the Client resides. For instance, money fields for USA, Canada, UK are shown as 123,456,789.00 and then "$" or "£" symbol; but European countries should have 123.456.789,00 format and a Euro symbol.
I have found that XXX.XXX.XXX,00 format corresponds to the Language property = "Italian". If I set the Language property = "Italian" on Report or Cell level at design time, the report shows the expected 123.456.789,00 format, no problem. (By the way, for some reason, on the Table level this property set does not work at all)
Unfortunately, I was not able to change the Language property to "Italian" on Report or Cell level on-fly using the following expression: =IIF((Parameters!Symbol.Value="$" OR Parameters!Symbol.Value="£"),"English (United States)","Italian") For debugging, I even tried: =IIF((Parameters!Symbol.Value="$" OR Parameters!Symbol.Value="£"),"Italian","Italian") But all numbers on the report are still shown in the 123,456,789.00 format regardless the Client's currency symbol.
I don't want to have 2 sets of my reports only because if the monetary format difference. And also I don't want to CAST the monetary value into a string and mask it myself with dots and commas.
I appreciate at advance any help or comment regarding the issue very much. This is a critical bug and it must be resolved ASAP.
I have a websites contains many articles, instead of putting them all into categories, I prefer a more intuitive organizing way, so "tag" function is the first thing come into my mind,but i have no idea how i should design my database for tag support. Any ideas?
i have a question concerning the design time support when accessing different oracle database schemas with SSIS.
I'm using an OLEDB-Connection, and in general everything is working fine. I would like to access two different schemas. One for production and one testing. So i have stored my connection properties in a configuration file, which looks different for prod and test.
I'm not allowed to connect to the oracle db with the user in who's schema the tables are located. (e.g. schema=prod, my user=readonly)
Normally i must type SQL like: "select * from prod.MyTable" for my production datasource and "select * from test.MyTable" for my test datasource.
In order to clean up my sql i use the oracle "alter session" command. (alter session set current_schema=prod) The command is stored with the connection properties within my configuration file.
All of my packages start with this sql statement for the oracle datasource. (The connection property RetainSameConnection is true and the package property DelayValidation is set.)
So the solution is working fine.
But during the development i have a problem. When crating a datasource i can't retrieve the metadata infromation or build sql with the provided tools, because of "Table of View not found" (ok, the alter session statement is missing)
So does anyone know how to define a alter session for the design time conneciton? Maybe something with the "Extended Properties" of the connection?
I've tried several things to get my multi-select parameter to take more than one value but it seems to only take the 1st one I input. I've been working on this for days and been trying alternate methods but nothing seems to work. I think my first question is if I'm planning on using a parameter as a multi-select parameter what is the data type I should call that parameter. In my case here, the evt_key is unique and will always be 36 characters. I cant imagine in my lifetime that I'm going to have any more than 20 items in the multiselect. Am I looking over something or any other suggestions? I also attached my sp at the bottom.
begin insert #tempet select distinct evt_key from ev_event where evt_key in ('00394886-dfc7-4466-b674-1f2b3ede79ea', '10BE664D-DA4F-44F4-802C-ABD4FC015FB4','56504014-9787-4207-8FAD-EC6C6A384C1D') and evt_delete_flag = 0 end
else begin insert #tempet exec _selectstringfromstring @idstring = @evt_key,@intorstring='S' end
if @evt_key = '' goto finalselect set @evt_key = dbo.av_preprptguidparam(@evt_key,'returnnull')
*/
IF @evt_key='' SELECT @evt_key=NULL
insert into #tmp_dates select distinct reg_evt_key, evt_title, evt_start_date from ev_registrant join ev_event on reg_evt_key = evt_key --join #tempet on evt_key=tmpet_key where reg_delete_flag = 0 and evt_delete_flag = 0 --and reg_evt_key = '10BE664D-DA4F-44F4-802C-ABD4FC015FB4' and (@evt_key is null or (@evt_key is not null and reg_evt_key = @evt_key)) ---AND (@evt_key IS NULL OR (@evt_key IS NOT NULL AND reg_evt_key IN (SELECT item FROM dbo.av_SelectStringFromString(@evt_key,','))))
insert into #temp select tmp_evt_key, tmp_title, reg_key, -- net_prc_code, case net_prc_code when null then tmp_title when '' then tmp_title when 'NULL' then tmp_title when ' ' then tmp_title else net_prc_code end, 'Reg Code', cst_ind_full_name_dn, cst_sort_name_dn, cst_org_name_dn, dbo.av_end_of_day(reg_add_date), net_payamount, adr_city_state_code, adr_state, adr_country, adr_city, adr_post_code, src_code, datediff(dd, reg_add_date, tmp_start_date) from #tmp_dates join ev_registrant on reg_evt_key = tmp_evt_key join vw_ac_invoice_detail on reg_ivd_key = net_ivd_key join co_customer on cst_key = reg_cst_key LEFT JOIN co_customer_x_address x ON x.cxa_key = reg_cxa_key AND cxa_delete_flag = 0 LEFT JOIN co_address a ON a.adr_key = x.cxa_adr_key AND adr_delete_flag = 0 LEFT JOIN co_source_code o ON src_key = reg_src_key AND src_delete_flag = 0 --join #tempet on reg_evt_key=tmpet_key where reg_delete_flag = 0 and reg_cancel_date is null and cst_delete_flag = 0 AND (@evt_key IS NULL OR (@evt_key IS NOT NULL AND tmp_evt_key IN (SELECT item FROM dbo.av_SelectStringFromString(@evt_key,','))))
finalselect: select * from #temp --where (@evt_key IS NULL OR (@evt_key IS NOT NULL AND tmp_key IN (SELECT item FROM dbo.av_SelectStringFromString(@evt_key,',')))) order by days_out desc, type, reg_name GO
SQLServer7, NT4. We search on Employees, Locations, things like that. We use a bit column to designate whether or not the status of the employee or location is active or inactive. Knowing that you can't create an index on a bit column or making the datatype an integer and indexing the column would not help the query performance, does anyone have a suggestion on how they have improved their design for searches in cases like this? Thank you in advance for the help.