SQL or UNICODE

Home Answers Viewqa SQL SQL or UNICODE

Jatish Khanna

SQL or UNICODE
2 Answer(s) 3 years and a month ago
Posted in : SQL

Hi again............

I have got something new that...........

i was using MS Access as the database with my JAVA Japplet....

In my applet i used JTextArea to display the output .....
The output to display is fetched from the database which is connected using DSNless connection as with connection string...

My database contains two columns one with having ASCII and other With UNICODE

1]
when i trying to pass parameter to database i.e UNICODE and fetches ASCII it retrieves nothing to display

2]

when trying to pass parameter ASCII and fetches UNICODE it retrieves only [????] but exactly the same number of chars stored in DATABASE.......

acc. to me their is problem in SENDING and Retrieving the database bcz when trying to fetched ASCII it fetches the exact match and displays......

but with UNICODE nothing ......

I had also change my backhand to SQL SERVER but retrieves same for UNICODE [????] ..............

thanks
waiting for reply

View Answers

April 19, 2010 at 1:20 PM

Hi Friend,

In Access database, declare the data type 'Text' to both the fields.
You can use the following code to fetch the UNICODE value.

import java.sql.*;
import java.util.*;
class MSAccess{
public static void main(String[] args) {
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access");
Scanner input=new Scanner(System.in);
System.out.println("Enter Ascii value: ");
String ascii=input.nextLine();
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select UNICODE from Data1 where ASCII='"+ascii+"'");
if(rs.next()){
System.out.println(rs.getString("UNICODE"));
}
}
catch(Exception e){}
}
}

Hope that it will be helpful for you.
Thanks

April 20, 2010 at 6:46 PM

Ya i have Tried ..........

Can u make me sure THE UNICODE and ASCII are the columns nams......or something other

....................

thanks for posting reply........If u can contact me at cool_jatish@yahoo.com plz urgent.......needed

also can u tell me the method to use CLOB in java

SQL or UNICODE - SQL
SQL or UNICODE Hi again............ I have got something new... ...... I had also change my backhand to SQL SERVER but retrieves same for UNICODE... ASCII and other With UNICODE 1] when i trying to pass parameter to database i.e

Unicode - JDBC
Unicode hi i wanna retrieve Unicode values from the database...) or IN doc or RTF or WEB page it get the UNICODE as ????? what can i do so Language JAVA platform XP database SQL Server and MS ACcess

UNICODE or SQL statement issue - JDBC
UNICODE or SQL statement issue Hi again............ I have got... with having ASCII and other With UNICODE 1] when i trying to pass parameter to database i.e UNICODE and fetches ASCII it retrieves nothing to display 2

unicode - Swing AWT
unicode hi i wanna retrieve Unicode values from the database...) or IN doc or RTF or WEB page it get the UNICODE as ????? what can i do so Language JAVA platform XP database SQL Server and MS ACcess

Unicode - Java Beginners
SQL SERVER 2005) So please give me a proper solution fixed this issue

unicode

Java Unicode
Java Unicode To insert Unicode word into MySql database using Java

unicode characters
unicode characters class Unicode { public static void main(String args[]) { char ch='\000a'; System.out.println("ch is:"+ch); } } on compilation this gives following errore:: CharLiteral6.java:5: error: illegal line end

unicode handling in java
unicode handling in java reading a unicode text file in java

PDF Generation for unicode characters
PDF Generation for unicode characters Hi, How a PDF file having unicode characters is generated in JSP

Java: Unicode
Java: Unicode Unicode is a system of encoding characters. All characters and Strings in Java use the Unicode encoding, which allows truly international programming. About Unicode The Unicode effort is not coordinated with Java

Java unicode - Java Beginners
Java unicode I can read unicode character(malayalam language character) from a file but not able to print the character without installing a malayalam font(corresponding language font). Please help me to solve

Unicode - Java Beginners
Unicode How to print unicode value of a char. Eg. /u0000 on console(default value of a char) Hi Friend, Try the following code: import java.io.*; import java.util.*; public class Unicode { public static

How java work on Unicode machanish
How java work on Unicode machanish How the data are stored in java as unicode, how the conversions is done for input/output stream. Please describe in detail with memory aspect

Prinnt UNICODE character on swing component
Prinnt UNICODE character on swing component Hello, I am trying to put unicode character n swing component. can anyone tell me how to do this? Thank you

Conversion of unicode to its corresponding character
Conversion of unicode to its corresponding character i have a string of unicodes e.g String s="\c0059\c0049\c3000" .. i need code for converting these unicodes to its corresponding alphabets.. pls if possible rep asap as i need

Using Unicode Variable Names - Java Tutorials
Using Unicode Variable Names 2001-11-23 The Java Specialists' Newsletter [Issue 036] - Using Unicode Variable Names Author: Dr. Heinz M. Kabutz...". This week, we will look at the strange things that happen when we try to use unicode

unicode support in javascript - JSP-Servlet
unicode support in javascript We are facing problem while editing the tha text in a text box and sending it to next jsp. we are using UTF-8 encoding for jsp and charset as windows-874 for html meta charset. Can anybody help me

Convert String to unicode and ascii
Description: This example demonstrate how to convert the general string to unicode and ascii type Code: import java.net.IDN...; + unicode); } } Output

How to get the unicode of chinese character input in j2me/java
How to get the unicode of chinese character input in j2me/java Hi All, How to get the Unicode of a chinese character either in j2me or Java? Please provide the sample code snippet for the above ? Thanks in advance... Thanks

How to get the unicode of japanese character input in java
How to get the unicode of japanese character input in java Good... the text into japanese that needS to be converted as a unicode. for that I need a function,method or something through which i can get the unicode of japanese

sql
difference between sql and oracle what is the difference between sql and oracle

sql
sql how to get first row in sql with using where condition in sql? how to get last row in sql with using where condition in sql

unicode conversion to its actual text format
unicode conversion to its actual text format hi, i am saving the hindi text into the database. It is saving in db as "हिन्डि". But while fetching i am not able to fetch the same hindi text

sql
sql I want interview sql questions Please visit the following link: SQL Tutorials

Sql
Sql how to find maximum of a101,a102,a103 from a table in sql

Generate unicode malayalam PDF from JSP
Generate unicode malayalam PDF from JSP Hi, I want to generate... the same report to be saved as PDF in unicode malayalam font.I have tried to generate PDF reports using IText,but I dont know how to generate unicode malayalam

SQL
SQL hii What is sql? hello, SQL, which stands for Structured Query Language, is a special-purpose language used to define, access, and manipulate data. SQL is non procedural, meaning that it describes

sql
sql returning value from a store procedure in sql with example Please visit the following links: http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml http://www.roseindia.net/sql/create

Determining the Word Boundaries in a Unicode String
Determining the Word Boundaries in a Unicode String In this section, you will learn how to determine the word boundaries in a unicode string. Generally, we use split() method and StringTokenizer class to break the string into words

SQL
SQL In my computer i have microsoft sql 2008.how can i set that in the cmd.i want to use that in cmd.what is the default username and password

Determining the Sentence Boundaries in a Unicode String
Determining the Sentence Boundaries in a Unicode String In this section, you will learn how to determine the sentence boundaries in a unicode string. From the previous section, you all are aware of BreakIterator class. This class

SQL
SQL 1)How to Store 1000 records in Oracle object. 2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble. 3)What is Sequence. 4)How to use rowid in Sql. 5)What is Views. 6)How

SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using SQL Use the following queries to get the data from database in the given format. For (15 march 2011) format: SELECT DATE_FORMAT(dob, '%d %M %Y') FROM

SQL
SQL Trigger query Why we use the Trigger and what it's uses? A database trigger is procedural code that is automatically executed..., user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
tables EMP, and DEPT, the structure for which are given above. Write SQL queries

SQL
events, user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
, user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
events, and SQL statements to subscribing applications 10)Restrict DML

SQL

sql

SQL

sql

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics