write Greek ( or other non-ASCII/8859-1 ) characters to a database

How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

View Answers

November 15, 2010 at 11:54 AM

HI friends,

From the standard JDBC perspective, there is no difference between ASCII/8859-1 characters and those above 255 ( hex FF ). The reason for that is that all Java characters are in Unicode ( unless you perform/request special encoding ). Implicit in that statement is the presumption that the data store can handle characters outside the hex FF range or interprets different character sets appropriately. That means either:

  • The OS, application and database use the same code page and character set. For example, a Greek version of NT with the DBMS set to the default OS encoding.
  • The DBMS has I18N support for Greek ( or other language ), regardless of OS encoding. This has been the most common for production quality databases, although support varies. Particular DBMSes may allow setting the encoding/code page/CCSID at the database, table or even column level. There is no particular standard for provided support or methods of setting the encoding. You have to check the DBMS documentation and set up the table properly.
  • The DBMS has I18N support in the form of Unicode capability. This would handle any Unicode characters and therefore any language defined in the Unicode standard. Again, set up is proprietary.









Related Tutorials/Questions & Answers:
write Greek ( or other non-ASCII/8859-1 ) characters to a database
write Greek ( or other non-ASCII/8859-1 ) characters to a database  How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database
HOW WRITE GREEK CHARACTERS INTO MYSQL BY JSP ?
HOW WRITE GREEK CHARACTERS INTO MYSQL BY JSP ?  HALLOW TO ALL ! I'M USING MYSQL5.5 , TOMCAT7 & JSP. IN MY BROWSER I'M SEEING GREEK CHARS BECAUSE OF UTF-8 ENCODING . WHEN I RETRIEVE DATA FROM DATABASE BY SELECT * FROM
Advertisements
Java Cosole not Displaying Greek letters - WebSevices
, if i write simple program to print Greek characters it displays ??? please help me... got a new requirement to read Greek and Arabic characters from the xml and store...Java Cosole not Displaying Greek letters  Hello Team, I developed
write excel file into the oracle database
write excel file into the oracle database  dear sir, i need the jsp code that reads the excel file and stores it into the oracle database table..and also i need the code to connect oracle database? thank u in advance
Write a program to get student details and store in a database
Write a program to get student details and store in a database  Write a program to get student details and store in a database
how to write a query for adding records in database
how to write a query for adding records in database  How write fire query in JSP for adding records in database
if my database(oracle) connection failure means wat is the code to write in exception ?
if my database(oracle) connection failure means wat is the code to write in exception ?  if my database(oracle) connection failure means wat is the code to write in exception
writing characters
writing characters  how to write a group of characters to a string ... i mean for writing single character using charAt in java
How to Retrieve Data from the database and write into excel file using Java
How to Retrieve Data from the database and write into excel file using Java  Hi, I am trying to develop an small application where i trying to retrieve Data from the database and store the details in excel file. Please can
insert user session into other oracle database table
insert user session into other oracle database table   hello i am... account after that i store his name into session and when the user write any... table. with user id i also want to insert date and current time in to database
ModuleNotFoundError: No module named 'greek-stemmer'
ModuleNotFoundError: No module named 'greek-stemmer'  Hi, My... 'greek-stemmer' How to remove the ModuleNotFoundError: No module named 'greek-stemmer' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'greek-utils'
ModuleNotFoundError: No module named 'greek-utils'  Hi, My Python... 'greek-utils' How to remove the ModuleNotFoundError: No module named 'greek-utils' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'greek-accentuation'
ModuleNotFoundError: No module named 'greek-accentuation'  Hi, My... named 'greek-accentuation' How to remove the ModuleNotFoundError: No module named 'greek-accentuation' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'greek-normalisation'
ModuleNotFoundError: No module named 'greek-normalisation'  Hi, My... named 'greek-normalisation' How to remove the ModuleNotFoundError: No module named 'greek-normalisation' error? Thanks   Hi
ModuleNotFoundError: No module named 'greek-stemmer'
ModuleNotFoundError: No module named 'greek-stemmer'  Hi, My... 'greek-stemmer' How to remove the ModuleNotFoundError: No module named 'greek-stemmer' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'greek-utils'
ModuleNotFoundError: No module named 'greek-utils'  Hi, My Python... 'greek-utils' How to remove the ModuleNotFoundError: No module named 'greek-utils' error? Thanks   Hi, In your python environment
Retrieve data from the database and write into ppt file
Java Retrieve data from the database & write into ppt file In this section, we are going to retrieve data from the database and write into the .ppt file... of setText() method, we have inserted database values into it. Here is the code
Retrieve Data from the database and write into excel file
Retrieve Data from the database and write into excel file. In this section, we are going to retrieve data from the database and write into the excel file..., we have inserted the database table values in the excel sheet. Here
How to write a select box and id should be stored in database?
How to write a select box and id should be stored in database?  Hi, How to write a select box and select the name(devi) regarding name id(like 60) should be stored in database using SWINGS concept plz help   You
how to write a code for oracle database connection in asp.net for validation.
how to write a code for oracle database connection in asp.net for validation.  <script language="javascript" type="text/javascript"> function fill() { //<%@ import Namespace="System.Data" %> //<%@ import
how to write the coding for converting the database data for example population into any type of graph using jsp and servlets?//
coding for converting the database data  how to write the coding for converting the database data for example population into any type of graph using jsp and servlets pls help me out how to write the coding for converting
ModuleNotFoundError: No module named 'greek_sites_crawler'
ModuleNotFoundError: No module named 'greek_sites_crawler'  Hi, My... named 'greek_sites_crawler' How to remove the ModuleNotFoundError: No module named 'greek_sites_crawler' error? Thanks   Hi
ModuleNotFoundError: No module named 'jupyter-greek-latex'
ModuleNotFoundError: No module named 'jupyter-greek-latex'  Hi, My... named 'jupyter-greek-latex' How to remove the ModuleNotFoundError: No module named 'jupyter-greek-latex' error? Thanks   Hi
ModuleNotFoundError: No module named 'python-greek-names'
ModuleNotFoundError: No module named 'python-greek-names'  Hi, My... named 'python-greek-names' How to remove the ModuleNotFoundError: No module named 'python-greek-names' error? Thanks   Hi, In your
ModuleNotFoundError: No module named 'greek_sites_crawler'
ModuleNotFoundError: No module named 'greek_sites_crawler'  Hi, My... named 'greek_sites_crawler' How to remove the ModuleNotFoundError: No module named 'greek_sites_crawler' error? Thanks   Hi
ModuleNotFoundError: No module named 'jupyter-greek-latex'
ModuleNotFoundError: No module named 'jupyter-greek-latex'  Hi, My... named 'jupyter-greek-latex' How to remove the ModuleNotFoundError: No module named 'jupyter-greek-latex' error? Thanks   Hi
Java characters
Java characters  How many bits are used to represent Unicode, ASCII, UTF-16, and UTF-8 characters
image displaying from database with some other information
image displaying from database with some other information  hi, in the following section of code when i am not displaying the image it is working properly but when i tried to display the image nothing is displayed on browser
write spreadsheet
write spreadsheet  what is the java code to write a spreadsheet to database
write spreadsheet
write spreadsheet  what is the java code to write a spreadsheet to database
Unwanted characters instead of arabic characters
Unwanted characters instead of arabic characters  I am using... and using it to display. the problem is: I need to display some arabic characters here... صÙ?Ù?دÙ?Ù?Ø© سÙ?Ù?د Ù?Ù?Ù?Ù?Ù?أرب like characters instead of arabic
Count number of characters in a column.
found any other characters other than A,G,C,T...Please help me out...Count number of characters in a column.  I just need you suggestions. Am from Biology Back ground. I just need to find out number of characters
replace special characters in html
replace special characters in html  How can i replace the special characters in HTML?   Special Character in HTML HTML has a long list of special characters symbol that can be used anywhere throughout the HTML Code
Q6 Write a java applet that displays 9 squares, one below the other. Every third square must be filled in black?
Q6 Write a java applet that displays 9 squares, one below the other. Every third square must be filled in black?  Q6 Write a java applet that displays 9 squares, one below the other. Every third square must be filled in black
how do i update my database with the help of update syntax in html <text/javascript>? How to write 'where' statement in this?
how do i update my database with the help of update syntax in html ? How to write 'where' statement in this?  var sqlmek="update into Student_info set(ID,s_name,l_name,address,pincode,mobile_no,mail_id)values ("; sqlmek
How can I write a GUI stack program by Java to push Image files instead of other data type items?
How can I write a GUI stack program by Java to push Image files instead of other data type items?   How can I write a GUI stack program by Java to push Image files instead of other data type items? for the push instruction I
special characters in my HTML
special characters in my HTML  How do I get special characters in my HTML
special characters in my HTML
special characters in my HTML  How do I get special characters in my HTML
Protect Special Characters.
Protect Special Characters.  How To Protect Special Characters in Query String
ModuleNotFoundError: No module named 'characters'
ModuleNotFoundError: No module named 'characters'  Hi, My Python... 'characters' How to remove the ModuleNotFoundError: No module named 'characters' error? Thanks   Hi, In your python environment you
upload file and insert other details to database using a single form
upload file and insert other details to database using a single form   hi.. I have problem with uploading a file and insert other user datas together... but my other details seem to be null
remove special characters iphone
remove special characters iphone  remove special characters iphone   Remove special characters iphone from Password NSString *outputString = [passwordString stringByReplacingOccurrencesOfString:@"%" withString
Write to a file
Write to a file   ...; the BufferedOutputStream class that store the data in an internal buffer and lets you write characters to a stream. Lets see an example that writes the text "Hello Java"
PDF Generation for unicode characters
PDF Generation for unicode characters  Hi, How a PDF file having unicode characters is generated in JSP
regular expression for special characters
regular expression for special characters  How to find out regular expression for special characters
Removing characters from a string
Removing characters from a string  Removing characters from a string   Example: public class CharReplace{ public static void main(String []args){ String str="Hello 123.you are At 3456"; String
Write records into text file from database
Write records into text file from database You have already learnt how to insert records from text file to database. But here we are going to retrieve records from database and store the data into the text file. For this purpose, we have
finding the ip address of other system and store in the database - JDBC
finding the ip address of other system and store in the database  code to find the ip address,host name and their locale of other system... in database.if any other system tries to connect our system ,we have to find the ip address
Uppercase Characters in Java
Uppercase Characters in Java  I want to know how to UpperCase Characters in Title useing a java code...?   Use toUpperCase() method to convert the string in uppercase letters. class UppercaseString { public static
Limiting characters - JSP-Servlet
Limiting characters  Iam doing a jsp project. In this i have a text area which should accept not more than 300 characters. I solved this with backspace and delete keys. But, i cannot solve problem of pasting through shortcut ctrl

Questions by Category