Folowing procedure update fails apparently because comment contains non us
character 'ä'. Goes through without 'ä'.
Should this be so?
Pekka
unsuccessful
On Fri, 25 Apr 2014 07:01:31 +0200, Thomas Beckmann
thomas.beckm...@assfinet.de wrote:
You are right: Blobs are stored in separate pages. But having blob
fields inside tables with other fields forces these pages to be
allocated when record is created - whether the blob will contain data or
On Fri, 25 Apr 2014 07:38:13 +, Pekka Paunio
pekka.pau...@newsbrokers.fi wrote:
Folowing procedure update fails apparently because comment contains non
us
character 'ä'. Goes through without 'ä'.
Should this be so?
What is your Firebird version, and which connection character set do you
Yes, and it is running on Win 7 64 bit.
Pekka
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Pekka Paunio
Sent: 25. huhtikuuta 2014 10:56
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] non us characters in comments fail
Yes, I had one of these yesterday - part of a comment had been
cut-and-pasted from Word, and contained something that looked like an
ASCII minus but was in fact an em-rule.
Whether you get a failure or not, and at which point of the process,
depends, apparently, on all sorts of things,
There seems to be all sorts of annoyances that have to do with character sets.
For me it is not necessary to use non us characters but these things take time
unnecessarily.
Pekka
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Tim Ward
Sent: 25.
On 25/04/2014 09:14, Pekka Paunio wrote:
There seems to be all sorts of annoyances that have to do with
character sets.
For me it is not necessary to use non us characters but these things
take time unnecessarily.
There is a Cambridge Computer Science exam question:
Explain why even
Hello Tim,
Yes, I had one of these yesterday - part of a comment had been
cut-and-pasted from Word, and contained something that looked like an
ASCII minus but was in fact an em-rule.
Whether you get a failure or not, and at which point of the process,
depends, apparently, on all sorts of
I'm using v4.4.5.0. I can't check what others are using as they aren't
in the office just right now, but I would expect them to be on the same
version.
On 25/04/2014 09:23, Martijn Tonies (Upscene Productions) wrote:
Hello Tim,
Yes, I had one of these yesterday - part of a comment had been
On Fri, 25 Apr 2014 07:55:35 +, Pekka Paunio
pekka.pau...@newsbrokers.fi wrote:
Charset is UTF8 and Server version is 2.5.2.
Is that your *connection* character set or your *database* character set?
Also how are you executing this script? It is very easy for a tool to use
the connection
Hello Tim,
Hmm, if Firebird allows you to store such characters, I would expect
Database Workbench
to support it. ;)
If you can find a reproducible case, let me know.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL
This seems to be repeatable:
(1) Store the procedure in the database from Database Workbench with
connection character set none.
(2) You can now read it no problem using the same instance of Database
Workbench, but someone else who has Database Workbench's character set
UTF8 then gets the
You are right. I changed the connection charset to utf-8 and now it accepts non
us charsets.
Pekka
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Mark Rotteveel
Sent: 25. huhtikuuta 2014 11:38
To: firebird-support@yahoogroups.com
Subject: RE:
Have you tried something like this?
UPDATE Table_1 a SET a.Column = 1
WHERE a.PK IN (SELECT b.PK FROM Table_1 b WHERE conditon = criteria)
That did the trick.I was leaving out the a.PK IN portion.
Thanks
Em 25/4/2014 01:31, liviusliv...@poczta.onet.pl escreveu:
Hi,
But you also misunderstud advice.
Blobs are not stored in table with its other fields. In record exists
only blob id and blob is stored on separate pages. Then moving it to
separate table do nothing.
But i always prefere store
All,
I got handed a project to get a v5.5 IB database updated and migrated to
Solaris (x86 for dev, T5 LDOM for prod).
At this time the plan is to keep it on IB/Firebird but use more modern
(supported) platform.
First step of the project is to build a new working environment to do the
17 matches
Mail list logo