Storing And Retrieving Info In Non-English Languages
Sep 1, 2006
Hi,
I am tasked with creating a site in two languages: English and Farsi (Persian), which is a right-to-left language.
I am having problems with the Faris version when it comes to stroing and retrieving data. I can use Farsi fonts and type data into tables, but when I try to retrieve them they are displayed as ?????. I check the table and it says there were problems retriving data and asks to run the query again. When I click on "Execute SQL", the content of the fields that were in Farsi change to ?????.
I am new to MS-SQL and would appreciate it if you could tell me how to set up non-English database.
TIA.
View 16 Replies
ADVERTISEMENT
Jan 9, 2007
I have been thinking of using SQL server 2005 as i would like the flexibility i get through UDT. Retrieving the UDT data in managed could is ok but i would like to retrieve it in non .NET languages too.
For example lets say i create a UDT "Point". I insert data in a table that has some columns of type point.
Now is there a way i can get the data of the type point in a point object in non .NET languages like perl, python...
View 1 Replies
View Related
Jul 14, 2004
Is it possible to store multiple languages in one sql server.Now i have a sqlserver with US English.Can i store spanish and french data in the DB?If possible how can i store it...?
Thanks.
View 1 Replies
View Related
Jun 19, 2006
Hi,
Is there any way to retrieve index information for a database through a SQL query?
I usually query out tables structure, et al using INFORMATION_SCHEMA. Is there anything like that for indexes?
Thanks,
Paul
View 8 Replies
View Related
Jun 13, 2008
Kindly descibe how i can save image and retieve images with vb form. Also include vb code to execute the process.
View 2 Replies
View Related
Jul 8, 2007
I have a query that gets the tables, columns, indexes, index_columns for all tables in a data base.
But, I need to be able to select any data base on the server
and then drill down into the tables, columns, etc.
I looked at sys.databases but can't see how to relate that to the
sys.tables to extend my query.
Is there a way?
I've looked at the information_schema area and catalog views
but I don't see a solution yet.
View 7 Replies
View Related
Feb 18, 2003
Can you guys give me any specific classes I should read about to implement the above? Any specific methods?
Any webpage I should read?
Thanks for your direction/help!
View 22 Replies
View Related
Feb 20, 2006
I have a package that processes a flat file, which is generated by a separate system each weekday around 3:30AM. I would like my package to store the timestamp of the input file and compare it to the timestamp of the next day's file. If they are the same, then the package can exit without reprocessing a particular file again.
So, my first question is whether a package variable can be updated so that its value will persist from one run to the next?
Second, what is the syntax to retrieve the file's timestamp, either directly from the file connection manager or within a script task?
Thanks,
Phil
View 1 Replies
View Related
Dec 17, 2007
Hi There,
Can I store flash files in the database. I have a table with one of the columns as varbinary datatype. Previously, I was saving images (as filebytes) into this column. But now I need to implement something to store the flash file. So, is it possible to store flash files in the database and retrieve them and display them in an asp.net page?
Thanks a lot for your suggestion!!
View 8 Replies
View Related
Sep 17, 2007
Hello,
Please help me find solution to these questions?
1. How do I store audio and video files in sql server 2000.
2. Is it possible to store and retrieve audio and video files using t-sql
3. Which is the most efficient way to store and retrieve audio and video files in sql server
Your suggestions are most valued.
Thanks!
View 6 Replies
View Related
Aug 31, 2007
I hope I'm posting this in the correct forum (forgive me if I'm not) since I'm not sure if this is an issue with inserting an item into a db or the processing of what I get out of it. I wrote a basic commenting system in which someone my post a comment about something written on the site. I wanted to keep it very simple, but I at least want the ability for a user to have newlines in their comment without having to hardcode a <br /> or something like that. Is there a way for me to detect a newline if someone, for example, is going to their next paragraph?
Let me know if you need a better explanation.
Thanks in advance!
View 4 Replies
View Related
May 7, 2007
I want to be able to see when records have been added to a table. The issue is we have a DTS job scheduled to run every night. The developer who wrote it password protected it and doesn't work here anymore. I want to add a step to this series of DTS jobs and want to run it just prior to his job. Is there a way to see when the records are being added or when this job is being run? Thanks again, you guys are the best.
ddave
View 3 Replies
View Related
Dec 29, 2006
Hello there,I just want to ask if storing data in dbase is much better than storing it in the file system? Because for one, i am currenlty developing my thesis which uploads a blob.doc file to a web server (currently i'm using the localhost of ASP.NET) then retrieves it from the local hostAlso i want to know if im right at this, the localhost of ASP.NET is the same as the one of a natural web server on the net? Because i'm just thinking of uploading and downloading the files from a web server. Although our thesis defense didn't require us to really upload it on the net, we were advised to use a localhost on our PC's. I'll be just using my local server Is it ok to just use a web server for storing files than a database?
View 6 Replies
View Related
Apr 5, 2007
Can anybody tell me of any documentation or books that talk about working SQL and other Languages and give examples.
Thanks
Danny Dubroc
View 1 Replies
View Related
Apr 27, 2007
Hi,
how to defined add a language to the language selection on the Full-text Specification in columns designed like "Arabic language".
Regards
View 4 Replies
View Related
Aug 15, 2004
in my project I am using three languages in one data base (English, Arabic, Turkish),
the problem is when i search about arabic character, there is no results, and when i change the default language to Arabic and search about turkish character there is no result.
what can i do to solve this problem??
plzzzzzz answer me..
View 2 Replies
View Related
Sep 17, 2007
I need to create databases in other languages (ie French, German, Spanish). Basically what I have learned all that needs to be modified from my current English DDL is the collation.
My question is regarding indexes in these other languages. Will indexes that I currently have in English work in French, German, or Spanish as long as I have the correct collation set at the database level?
View 1 Replies
View Related
Oct 31, 2007
In SQL Server 2005 standar edition, is it possible to change the language for the product during the installation? I mean, if I purchase the product in a Spanish spoken country; However, I want my SQL 2005 in English, can I swicht language during the install process? I an buying the software and the salesman says that I can chosse the language during the install, is that true?
THX
View 1 Replies
View Related
Sep 25, 2015
I was wondering if there was a strong need to learn scripting languages to elevate your level of skill, in regards to database development.
Would Python or Powershell be good to pick up to handle tasks in and outside of the RDMBS?
View 7 Replies
View Related
Jan 11, 2007
how to configure sql server 2005 to support foreign language?
i mean, i need to support asian language in my sqlserver. what are the
things to consider while designing the table and the databases as well as entering the data to the table.
It would be fine if someone could reply me with all the detail configuration and things to consider if i am to let my sqlserver support chinese language.
View 4 Replies
View Related
Jul 20, 2005
Hi,Can the English version of Sql Server (or other DBMSs) store data/records inother languages (e.g. French, Chinese, etc.) ordo you have to use the French version of Sql Server to store French data?Where can I go to read more on this?Thanks.Eric
View 1 Replies
View Related
Apr 14, 2007
HELLO ALL!
select * from sys.fulltext_languages
this query results nothing, so I need to add languages to sqlserver to be used with FTS.
Is there any way to do that???
THANK YOU!!!
View 6 Replies
View Related
Aug 17, 2006
Is it possible to a memo field in English and another memo field in say, Chinese or Frech or anything other than English in the same table?
Thanks.
View 1 Replies
View Related
Jan 24, 2008
Hi,
My source is Excel and one column has data in different languages. But when i try loading it to my Database errant data gets loaded.
I tried loading data to Flat file with no success.
Thanks in advance.
View 1 Replies
View Related
Aug 26, 2007
Hi,
I Use Ajax auto suggest text box. this autosuggest text box lookup throw table string field(nvarchar).It works find for Numbers and English words. But When I use LTR languages like arabic,the textbox does not show anything at all.
I use UTF-8 and when I search this field it leads to correct results. and I use "sql Latin1 CP CI AS"but I don't know what is the problem with it.
View 3 Replies
View Related
Apr 11, 2005
All,
I am working on a project where I need to save numberous unicode languages in the same table (Chinese, Japanese, Thai, etc.). I understand that I need to setup the columns to use the nchar, nvarchar, etc. as a column data type. What I am struggling with is which coalation to use. Is there a generic Unicode coallation that I can/should use on the DB, along with the nchar, nvarchar, etc. and making sure that my code is using the N declaration before all string values that are going into the DB.
Is there anything that I am missing on setting up the DB to support this?
Thanks,
Richard
View 2 Replies
View Related
Mar 31, 2014
Is there a way to make a single insert (in a loop) and take system dates and insert them in different languages without making a new loop for each language.
Example
Create table dateLanguage(
monthName nvarchar(20),
monthNameEs nvarchar(20),
monthNameFr nvarchar(20),
MonthNamePt nvarchar(20)
)
So for example
January,
Enero,
Janvier,
janeiro
View 3 Replies
View Related
May 11, 2006
Hi
We have an application we are developing that will run worldwide. When we are searching data for peoples names I would like to use Soundex but I am not sure it works effectivly for any language other than English. Does anyone know if it is effective in Dutch, German, French etc?
View 7 Replies
View Related
Feb 5, 2008
Hi,
I have got a column which should multi languages data(Chinese,English etc).
Source for this data is Excel.
I have kept this column DataType as NVARCHAR but Chinese data is shown as 'Boxes'.But when i copy this and paste on Query pane i get proper data.
Is the first thing doable?
Hoe can i accomplish this?
Thnks
View 2 Replies
View Related
Mar 1, 2007
Dear Friends..
I need help if any one can... My need is that...I am devloping my Cube using SSAS. I want to access my cube in multi languages e.g.: English, Japanese or other. At the movement I have two languages description in SQL Database like English and Japanese.
But In SSAS Translations, I can translate Measures Groups, Dimensions, Perspectives, KPIs, Actions, Named Sets & Calculated Members names. But there will be a need to Map Columns as per selected Lenguage so that I can display in proper language data.
Suppose I select Japanese the description should come from Column where Japanese description is stored.
OR any othere method by doing I can see my reports/data in any language.
Please Help...
View 7 Replies
View Related
Aug 24, 2004
hi there, i'm having a real problem here.
I have some foreign language encoded characters in the database. They are those characters that makes no sense when using the wrong charset to view them. Now I need to retrieve them from the database and re-insert as unicode so that they can be viewed properly.
Now the problem is this: when I retrieve them from the database using java, some characters tend to contain single quote (') or brackets in there, thus screwing up my whole update statement. Below is the coding I am using. It works when there isn't any single quotes or brackets.
Connection con = db.getConnection();
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select b.en_transID, b.trans_content from translations a, en_translations b where a.en_transID=b.en_transID and a.language_ID='3'");
while (rs.next())
{
String original = rs.getString("En_transID");
byte bytes[] = rs.getBytes("trans_content");
if (bytes != null)
{
String s = new String(bytes, "UTF-16LE");
s = new String(s.getBytes(), "big5");
Statement tempStmt = con.createStatement();
tempStmt.executeUpdate("update En_Translations set trans_content = (N'"+s+"') where En_transID = '"+original+"'");
tempStmt.close();
}
Is there any way to get around this? Please help! Will appreciate it very much!
View 1 Replies
View Related
Feb 27, 2006
Hi,
I have an access database that is storing text in english and chinese characters. I am importing the data using SSIS and it is putting a 'square' character in place of all the chinese characters. Can I associate multiple code pages to a control? If this is not possible, I would just like to Extract the data and Load it into a table, and i will just handle the errors and write the key fields to an error log. The problem is that the error handler is not redirecting the row. It just simply fails. I have changed all the error actions to Redirect Row too. I currently have a script checking if the 'square' character exists but i feel this should be handled a better way? Has anyone run into this issue or have any suggestions??
This is the error code i get
Data conversion failed. The data conversion for column "FDCDOPS0" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
View 5 Replies
View Related
Feb 19, 2006
I have a view that retrieves the details for sys.messages in SQL Server Express and noticed that the language ID is 1033 (U.S. English). I will need French and Portuguese, and understand that these are standard. Is there a set of DDL Scripts that will install the sys.messages for these languages?
thanks,
Flavelle
View 1 Replies
View Related
