o
k
q
u
e
s
t
i
o
n
s
.
c
o
m

Unicode & Database -

Hi guys
I was working on Unicode for a while and finally I learned how to use it in order to show Chinese, Arabic, and Indian etc. I show them on “MS forms 2.00” which is consisted of controls that support Unicode. Now I can display and type any language in them. BUT a few problems:
1.How can I store a Unicode string in to a database (a mdb for example)?
2. how can I restore Unicode strings form a db?
As an Unicode character is a 2 byte one and a simple ASCII char is 1 byte. a database string field refuses to accept my Unicode string.
Any suggestions? I’m thinking of using the binary field type but it is limited and also I think it will work very slowly besides I’ll have to say goodbye to SQL queries.

 

Unicode & Database -
Hi guys I was working on Unicode for a while and finally I learned how to use it in order to show Chinese, Arabic, and Indian etc. I show them on “MS forms 2.00” which is consisted of controls that support Unicode. Now I can display and type any language in them. BUT a few proble

Unicode Controls in VB6 -
As far as I know that VB6 controls are not Unicode aware. I want to develop an application that uses Unicode. Basically I want to use Bengali Unicode font in one of my database application. But all VB6 controls are not Unicode aware. Only MS Froms 2.0 coltrols are unicode aware. but

saving unicode text to sql db -
sir, i developed an application in visual basic 2005 express edition. i am using sql server 2005 express as backend. i want to store unicode text in my sql database. but when i am saving unicode text to the database, i see only question marks instead of unicode text. to save unicod

unicode in sql statement -
I migrated my database from MSAccess 2000 (Chinese version) to MSSQL 2000 (English version). My database contains a lot of unicode data. The following sql statement somehow fails after the migration. sql = "SELECT * FROM TABLE1 WHERE Theme = '´¶³q' AND [Show]=1 ORDER BY [Mov

I can not query unicode data in SQL server2000 -
Dear Blade Thank you every much that you tell me how to insert unicode to sqlserver2000, but now i have the new problem is that i can not query my data from SQL Server2000 by using "select from where" statement. i try to use 'N' before the Unicode string also but not wo

Which supports unicode ADO 2.5 or ADO 2.7 in Oracle 9i -
Hey i am working on unicode application integrated with database 9i, So, what version of ADO supports Unicode character set .... thx

Data binding, DDE & OLE in user controls -
I've noticed there are some events such as LinkClose and LinkOpen, and others such as OLE_CompleteDrag. This far I've failed to find any information on how these could be implemented in an user control (or if that'd even be necessary), so I'd be grateful for any information. I also

Unicode 101 -
All I need to do is to write unicode chars to a file that will be viewed using notepad. There are two issues that I've run into with this: 1. How do I translate a unicode char's hex notation to get vb to put it into a file? 2. When you create a file using notepad and paste

String conversion to Unicode using vb6 -
Hi, I am trying to convert the string in VB6 to unicode. I am using strconv function to do so. But i am not able to save it properly in database. The characters get stored as ???? or some junk any ideas... can u send me sample code to convert string to unicode.

Crystal report - unicode problem -
I converted an Access-2000 database to SQl Server database. Crystal reports are generted using DSN point to Access database. these reports are running well .When i convert the database to SQL server the reports giving the following error(after setting the location of the SQl server dat

Using Unicode in VB -
How can I use Unicode in VB, for example, I can use Unicode when using database. Thanks!

Does SQLServer 2000 support Unicode v4.0 -
Hi all! I work with a database and the data in this database is all Khmer Unicode. When in insert data into data base the data i have inserted is all "?", but when i insert direct in the that field it is the Unicode.when insert from application it is "?". I do n

How to check whether the input is UNICODE or not -
I use MS SQL server 2000 and one of my column is nvarchar. That means users may enter non-unicode or unicode string. In asp, how can I check whether the data in that column is unicode or not? Please provide solution code. Thank you

Encryption for Non-Unicode Text -
hello. i've tried the RSA cryptography, which works perfectly for unicode texts, but not for non-unicode ones, like Korean. is there a way to encrypt non-unicode texts? i was thinking maybe messing around at the binary level would work. complexity doesn't matter for me any

Unicode in RichTextBox -
Dear sir: I'm trying to display unicode (e.g. U+0960) in TextBox (MS form 2.0 controls) and RichTextBox ( Microsoft RichTextBox 6.0 (SP4) ) controls. It works in TextBox, but not in RichTextBox. I think RichTextBox after 2.0 supported unicode. I also tried by changing several unicode

display unicode char in textbox -
Hey all, I wanted to create a program that would mix regular text and unicode charters in a "output" textbox the problem i run into is that when i display charters in unicode they just show up as blocks? is this a limitation of the textbox or is it a font issue? i

Unicode in VB6 and MSForms 2.0 Library -
OK, the previous threads I read talked about using PostMessageW/A or the Microsoft Forms 2.0 Object Library. The PostMessage doesn't work in VB6 (if the password character in the parameter field is set to a Unicode object) as VB6 does not support Unicode. [my development environm

how to insert the unicode to mysql -
Hi all! i try to insert the unicode to mysql by using INSERT statement, but data that inserted is not unicode it is latin character not code of uncode. so how can i insert unicode from php. best regards, thirith

I don't want my asp.net page use Unicode.How -
My client doesn't want to use unicode because his pocket PC doesn't works well with it.But it seems that asp.net use Unicode by default though I set charset=gb2131 or any charset else. How to make my page don't use Unicode but other charset?

inserting unicode text to mysql database -
Sir, i am using using vb6 and mysql. i am using vb6 to enter datas to mysql database. my problem is i can't insert unicode text to mysql database. i am using microsoft form control's text box to enter unicode (vb6's textbox doesnot support unicode. isn't it?) when i insert textbox con

Unicode help -
I'm using win 2000 Pro with Visual Interdev. My asp contains Unicode, so Interdev will force me to save my asp file as Unicode format. But after i saved , i cannot execute the asp file which is unicode format..... any one can help one that ? thanks u very much !

unicode and dll's -
I am placing a string constant within certain VB files which will act as versioning. When the code is compiled into dll's VB converts the constants into unicode. Is there any way to override the conversion of these strings into unicode ?

Prevent unicode users from running my non-unicode app -
I want to prevent users from running my app if their OS Unicode settings are going to cause trouble for my non-unicode aware VB6 app. Anyone know a foolproof way to determine this? TIA

Unicode *Resolved* -
Hi, Does anyone know how to convert a character, (say the letter 'a') into its unicode, (numeric), value. I know we can convert into the Ascii value using Asc(), but is there one for unicode? Cheers

Restore Problem -
Hi there, I am trying to restore a .bak file from another system. But it says that the UNICODE LOCALE ID on both machines r same. I Tried Import & Export (MS DTS) But it fails transfering half the data. Is it because of diff unicode ?? How should I change the UNICODE? IS there

Unicode to ASCII & ASCII to Unicode for ircx server -
Ircx servers convert Unicode to ACSII so that non-unicode clients can still work on the ircx server. I think there is standard convertion that ircx server uses like Microsoft exchange server. Anyone know where i can find the details for this convertion? Or Vb has some built in fu

multilanguage in vb6 -
How to get unicode string from vb6 controls? We are setting font.charset to the control. but when we enter data in a language, we are not getting unicode data from the control. Even if we use forms2.0 controls also we are not getting unicode data. Is there a way to get unicode d

Unicode ListBox, problem... -
Hello folks, I have a problem while trying to get the size of a unicode listbox, for standard listboxes (no unicode) all is ok, in that case I use the following instruction: numItems = SendMessage(listBox_hWnd, LB_GETCOUNT, 0&, ByVal 0&) but I don't know which instructi

Unicode in VB 6.0 (Please Save me!) -
Dear Sir, Last time i am able to solve Greate problem from this forum Thanks to all Experts, Now i am working on VB 6.0 and unicode I add "MS Forms2.0 Object Library" this and insert text box but still i can not write Unicode char in this textboxes is there any settin

Ansi/unicode -
If I want my application's character set to be neutral (as opposed to strictly ANSI or UNICODE), I'm aware of the declaration of TCHARs instead of CHARs and using functions such as _tcscat instead of strcat, what else would I have to do for the preprocessor exactly to be able to

Unicode Compression -
Hi: I want to put the "Unicode Compression" in access database in "true" but I had found nothing about the instrution to do this: this is the code for "allowzerolenght": fld.AllowZeroLength = True and for unicode compression? Thanks

convert ascii to unicode -
how to convert acii to unicode can we convert an ascii string to unicode string and store the converted unicode string in variable

Copying to clipboard HELP PLEASE! -
hi everyone.. I have some unicode text stored in access database (which is fine). I can copy and paste directly from access to MS word and unicode text displays fine. However, if i COPY the text (by connecting to the database through vb) and using: clipboard.settext rs.fie

UniCode Folders Name's Could we Recognize it -
with command prompt we can rename the folders with unicode chars to protect it some times. we all know the the windows couldn't read the unicode chars so, is there is a way to searching for any folder's which renamed with the unicode chars and open it with visual basic ??

Sinhala unicode -
Hi all, I would like to display sinhala unicode characters (unicode range D80 - DFF) in forms 2.0 using the chrw() function. However all the characters show up as blocks. I even tried changing the font to tahoma/Verdana. Please advice Ashanth

How to detect unicode when using ADO GetChunk -
When reading a longBinary field in the database with getchunk how do you 1 - detect unicode 2 - convert it to standard character format

Specifying unicode when launching java from vb -
I am using this command: bSuccess = ShExecEx(lpBatchCmd, lpParams, lpPath, hwnd) I have set up my lpparams but I have not been able to specify unicode. Anyone know the command to specify unicode? Thanks, Randy

Unicode LPCTSTR to ANSI CString -
Hi there, i am trying to get a Unicode LPCTSTR variable to to display in an EditBox which is CSTRING, at the moment it only displays invalid characters, which makes me think the data is coming in as Unicode. is there anyway to convert between Unicode LPCTSTR and ANSI CString formats?

Unicode To ANSI FORMAT -
Hi Everyone, i have been assigned a task. i have to convert a 100 unicode files into ascii text files. i have found out a method of identifying whether a file is unicode or not. This method is working for all the unicode files. However I am not certain how do I automate the tas

Unicode Compression in Jet 4.0 -
I can't for the life of me figure out how to set the Unicode Compression option in code for fields in my tables. I'm using DAO 3.6 to modify the fields and I can't find the function. For a DAO database, I'm doing as follows... DAODatabase.DAOtblDef.Fields(Index). I would