Japanese and PostgreSQL - PostgreSQL Database

Deibys Fernando Quintero

Hello There ,
I hope u answer these questions:
I have installed postgresql DBMS , with SQL_ASCII
encoding, so far, it is working ok, I think I might
have probelems when manipulating the
strings(substri ng, lenght), but now I don't do i.
Could anyone tell me , with reasons, the best
encoding?
Also I would like to do text search, I 'd like to use
a full text search engine, Could anyone give me a hint
what
it is the best solution for japanese characters ?
I have looked at tsearch , but I am not sure.
I would appreciate any reply as soon as possible.
deibys

_______________ _______________ _______________ _______________ ____________
Want to chat instantly with your online friends? Get the FREE Yahoo!
Messenger http://mail.messenger.yahoo.co.uk

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

Nov 12 '05 #1

Subscribe Reply

1612

Jean-Michel POURE

Le Mercredi 19 Novembre 2003 06:10, Deibys Fernando Quintero a écrit :

it is the best solution for japanese characters ?

You can use a Unicode database and pgAdmin3 client
which supports UTF-8 Unicode:

http://www.pgadmin.org

Best regards,
Jean-Michel
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #2

Jean-Michel POURE

Le Mercredi 19 Novembre 2003 06:10, Deibys Fernando Quintero a écrit :

it is the best solution for japanese characters ?

Nov 12 '05 #3

Similar topics

9079

Read and display Japanese text from text file

by: David Thomas | last post by:

Hi there, a while ago, I posted a question regarding reading japanese text from a text file. Well, since I solved the problem, I thought I'd post my solution for the benefit of other people with the same problem. The plan was to make a script to read and display japanese text. I will use it for making a japanese proverb script and for a japanese language study script.

PHP

5156

Japanese in MySQL

by: Keitaro | last post by:

Hi, I am developing a vocabulary trainer. The languages I want to support are German and Japanese. When I try to store Japanese characters in my mysql database, I do not get the correct characters. The entry of the field is "???" instead of the Japanese character. I tried to store the character with my java application and with the MySQL Control Center. I know I have to configure the mysql database. But I do not know how. I created my...

MySQL Database

1660

Transcode Japanese??

by: Robert M. Gary | last post by:

I'm on a Solaris 9 Japanese machine w/ an Ultra 5 Sparc CPU. I'm using Xerces 2.6 DOM I've got a document in UTF-8 format.. <?xml version="1.0" encoding="UTF-8"?> <Name>ja_alert-\343\201\250\343\201\241\343\201\244\343\201\252\343\201\256\343\ 201\253</Name> (I'm not sure if the Japanese came out right here, but everything after ja_alert- is UTF-8 for Japanese).

.NET Framework

4824

japanese language

by: Sven Hanefeld | last post by:

Hi, who is able to help. I want to translate my whole website into japanese language. www.nord-com.net/hanefeld What do I have to do except finding a japanese guy for the translation. Do I need to install a japanese operating system. What kind of editor is nessasary? With the unicode system I can translate Katakana and Hiragana, but no Kanji. And it is very awkward

Javascript

2587

displaying japanese text on English OS

by: Benoit Martin | last post by:

in my windows app, I have some japanese text that I load from a text file and display on a label. No matter what type of encoding I try to use on the text file, the text always comes up as a bunch of unreadable characters on my label. Are there settings/properties for a label on a windows form to be able to read japanese text? Is it when I raed the file that it gets screwed up (I use fileOpen and LineInput)? Looking for pointers here

.NET Framework

363

Japanese and PostgreSQL

by: Deibys Fernando Quintero | last post by:

PostgreSQL Database

2515

Prototype, Safari and Japanese problems?

by: Doug Lerner | last post by:

I'm working on a client/server app that seems to work fine in OS Firefox and Windows IE and Firefox. However, in OS X Safari, although the UI/communications themselves work fine, if the characters getting sent back and forth are in Japanese they come back from the server "moji bake" (corrupted). Anybody have any ideas why this might work differently in Safari than in Firefox or IE?

Javascript

5810

Japanese - wrong encoding in a frame

by: paulgor | last post by:

Hi, May be it's a know issue but my search brought nothing... We have static HTML files with Japanese text in UTF-8 encoding - it's on-line Help for our application, so there are no Web servers involved, just .html and .js on a hard drive. .. Help topics are shown in a frameset (I know, I know, I personally had no idea :)) like this (I made an example): http://RusWin.net/jindex.htm

HTML / CSS

3094

Storing some Japanese data.

by: tony.pahl | last post by:

We are converting a data warehouse to a Unicode database to get ready for multilingual support. If we will have 95% of our data in English as we currently do, and less than 5% in other foreign languages including Japanese, it appears as if we would be best off using codepage of 1208 and UTF-8. We are thinking we would need to expand our 'char' and 'varchar' datatypes by four times to accommadate the Japanese data. Using 'varchar' should...

DB2 Database

3217

Japanese charset support in GetXmlHttpObject()

by: eros | last post by:

Please tell everybody on how to support different languages using AJAX. I've been searching this for a long time in many forums in the internet but they did not solved or post the definite solutions. Here's the printscreen: (please do copy and paste if not displayed here.) output via php and html (http://anime.geocities.jp/rozvinbm_jp/shops.JPG) http://anime.geocities.jp/rozvinbm_jp/shops.JPG output via php, html and processed with...

Javascript

10403

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

9208

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7671

Access Europe - Using VBA to create a class based on a table - Wed 1 May

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...

Microsoft Access / VBA

6893

Couldn’t get equations in html when convert word .docx file to html file in C#.

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();...

C# / C Sharp

5555

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5693

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4341

transfer the data from one system to another through ip address

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

C# / C Sharp

3868

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

3020

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General