Hello everybody!
I have a database that's supposed to hold data in different laguages, such as english, spanish, hebrew, german and french, but in priciple users may want to store info in any language. The charset I'm using is utf8 and collation utf8-general-ci, so that any character is correctly stored, however I've just found the following problem:
-When I insert any special character of german language it doesn't get stored correctly, for example the ß is represented as ß, however if I update the database, then it's well represented, so that makes me think the problem is just in the insertion. The same happens with the è character of the french language.
Am I using the wrong charset or collation? Which one should I use instead? If this is the problem, then why the update operation works? I would expect it not to, and however it does...
Please, if anyone has any idea and can help me out with this, I will really appreciate it, it's a big issue I've been having and I can't seem to find a solution for it yet.
Thanks in advance,
Kenia
1  2531  Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Salgoud Dell |
last post by:
I have a VB6 application running on a French computer using Windows ME. The
app doesn't work the same way as it does when running on an English Windows
OS.
The main issue I have, that I can't seem to overcome, is that the english
text font size my program thinks is available doesn't seem to be there.
Although a line of text printed on a US Windows machine looks fine, when it
is printed from this French computer the tabs are over written...
|
by: Philippe C. Martin |
last post by:
Hi,
I'm getting pretty desperate here:
The code below crashes on the last line (but works from a shell).
The class 'BC' exists and the loop on self.__BC_EXEC_LIST passes fine.
It's got to be something really stupid but I've been looking at it too long
I guess.
|
by: Peter Eisentraut |
last post by:
Greetings.
The official PostgreSQL documentation has been translated to German and
has been published as a book by verlag moderne industrie/mitp
("PostgreSQL: Das offizielle Handbuch", ISBN 3-8266-1337-6, see
<http://www.mitp.de/vmi/mitp/detail/pWert/1337>). I am the translator of
this work, but let me assure you I don't get any additional money
depending on how much it sells. On the other hand, the publisher has
assured me that a...
|
by: Dany |
last post by:
Our web service was working fine until we installed .net Framework 1.1 service pack 1. Uninstalling SP1 is not an option because our largest customer says service packs marked as "critical" by Microsoft must be installed on their servers.
Now german Umlaute (ä, ü, ö) and quotes are returned incorrectly in SOAP fault responses.
This can be easily verified:
Implement the following in a web service method (just raises a SOAPException with a...
|
by: HelmutStoneCorner |
last post by:
Hi,
I am connected as a german client to a multilanguage server, Regional
Options: English, US. Western Europe and US. The W2K Server (Terminal)
-version: english(US) runs a french database. My regional options are:
General: English, US, (Keybd: german). I create a new database and,
opening the table or going to the options, I get: An error occurred and
this feature is no longer functioning properly - then: Selected
collating sequence...
| | |
by: alainpoint |
last post by:
Hi,
I have what in my eyes seems a challenging problem.
Thanks to Peter Otten, i got the following code to work. It is a sort
of named tuple.
from operator import itemgetter
def constgetter(value):
def get(self): return value
return get
def createTuple(*names):
|
by: Just4U |
last post by:
Hello,
I take an old post because, nobody seem to answer my problem.
Config: Windows 2003 x64 (US) + sp2
Regional settings : French (for all & default users)
Basically I have the following code on my server
|
by: Charles |
last post by:
I'm designing a C++ application for the web (with FastCGI) and it has
to use UTF-8 because there will be users who will type Asian glyphs.
When I compile the application, if I use ANSI, no problem, it compiles
properly. But if I save the files as UTF-8, I get this error message:
%g++ -o cgi-bin/test.fcgi test.cpp
test.csp.cpp:1: error: stray '\239' in program
test.csp.cpp:1: error: stray '\187' in program
test.csp.cpp:1: error: stray...
|
by: arnuld |
last post by:
Next month I will start to work on a C++ based Software named CAT++ which
is going to provide FORTRAN like arrays in C++ and will be used within
Scientific Community and hence will heavily depend on
Numerical-Computations. I was reading 29.16 ans 29.17 sections of FAQs:
http://www.parashift.com/c++-faq-lite/newbie.html#faq-29.16
as a test, I just tried this program on Linux, GCC 4.2.2 and it gave me 2
different results:
|
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...
|
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,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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();...
|
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...
| | |
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
| |
