473,666 Members | 2,474 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

URGENT Problem with Greek Character from an Oracle database

ekekakos
4 New Member
Hello, I am having a serious and urgent problem with the character settings of an oracle database. The database is sitting in a solaris unix server and when we run the env command we have the following in the NLS_LANG parameter: AMERICAN_AMERIC A.WE8ISO8859P1 (I do not know if this is helpfull). When I retrieve data from oracle database (through a VB.NET 2005 program) to a dataset I use a special font in order to see the greek characters (HELLASARIAL) in the datagridview of the window form. But when I am trying to save these data to a TXT file the greek characters are like chinese to us. I tryed several encodings (System.Text.En coding.GetEncod ing(869)) but without success. Can someone tell me how to convert the oracle greek characters during the selection to the dataset or during the saving to the TXT file?

Please respond as fast as you can.
Thanks in advance

PS All these happens in VS2005 with VB.NET, the oracle database is 8.1.7.4
Sep 23 '06 #1
0 2135

Sign in to post your reply or Sign up for a free account.

Similar topics

9
3694
by: Ksenia Marasanova | last post by:
Hi, I have a little problem with encoding. Was hoping maybe anyone can help me to solve it. There is some amount of data in a database (PG) that must be inserted into Excel sheet and emailed. Nothing special, everything works. Except that non-ascii characters are not displayed properly. The data is stored as XML into a text field. When I use pgsql it's displayed good in the terminal. Now I run my script and print data
1
7186
by: M Mueller | last post by:
OS - Windows NT 4.0 Enterprise Edition DB Version - 8.1.7.4.1 When trying to change the Character Set from US7ASCII to WE8MSWIN1252, we complete the following steps from SVRMGR, connected as internal: SHUTDOWN IMMEDIATE; STARTUP MOUNT EXCLUSIVE; ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
0
5395
by: sedefo | last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access Application Block (DAAB) in our .Net projects. We use SqlHelper in SQL based projects, and OracleHelper in Oracle based ones. OracleHelper was not published officially by Microsoft as part of the DAAB but it was given as a helper code in a sample .Net...
0
1242
by: Vangelis Natsios | last post by:
I run a MySQL Server (v. 4.1.5-gamma) from a binary distribution on a SuSE 7.0 Linux. The default character set for the server is utf8 (runs with the flag --default-character-set=utf8). The utf-8 encoded databases I have seem to work fine. But I want to create another database with greek (iso-8859-7) encoding from a dump from a 3.23.X server with default character set "greek". Is this possible? When I try to feed the dump into my server...
4
2027
by: ljubo lecic via AccessMonster.com | last post by:
I am an experienced ORACLE software developer who met ACCESS few months ago and I must say that ,so far, I am delighted. I rapidly developed a few aplications and everything is working extremly good. Now, I am offered to develop something more complex. And It must be done in ACCESS.I feel so comfortable in ACCESS programming that I am about to accept the offer.But before my final response I URGENTLY need some advices and opinions from...
1
3216
by: Manolatos Tilemahos | last post by:
Dear friends, First pls accept my apologies, because I am a new Postgres user, so my questions could be silly. We need to setup a database using UTF-8 encoding, however, by some way, we have to express our need for right Greek character collation order. I tried the default installation using pginstaller, then I created a db (using pgAdminIII) using UTF-8, but still the collation is wrong (=wrong upper() and "order by") for Greek...
0
4352
by: Matt Wood | last post by:
Hi, I have written a Web Service for a customer which expects a SOAP message with Document/Literal encoding, and uses RoutingStyle=SoapServiceRoutingStyle.RequestElement to route the SOAP body message to my Web Method. The Web Method expects a string as its parameter and then feeds that string to an XML deserializer which maps the XML elements contained within the string to my custom objects, then performs an insert/update on an SQL...
3
2443
by: optionsindia | last post by:
hi partners, we are having a urgent requirement for one of our client cmmi level5 company in hyd if u intrested Kindly mail your responses to gangadhar.sadhu@optionsindia.com Project Lead - JAVA / ORACLE Job Profile Through understanding and expertise in the various phases of SDLC
6
17419
by: starman | last post by:
Hi all, I'm having trouble trying to enter/retrieve Greek characters. I have an astronomical dbase in MySQL. As you may know, lots of sky objects have Greek letter names (alpha Centauri, etc) but I want to enter these - and have the user see them - as the actual greek characters. Copying and pasting from character map doesn't work (if I copy the greek letter gamma, when I paste it into the field in PHPMyAdmin it comes out as "g" and likewise...
0
8440
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8352
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8780
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8549
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6189
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5661
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
2765
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2005
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1763
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.