Hi!
Does DB2 handle extended ASCII table?
Example:
VALUES(CHR(65)) =A
VALUES(CHR(129) ) =null, but according to www.asciitable.com should be u
with umlaut.
Any idea ?
Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- 17  11827 
Gregor Kovac( wrote:
Hi!
Does DB2 handle extended ASCII table?
Example:
VALUES(CHR(65)) =A
VALUES(CHR(129) ) =null, but according to www.asciitable.com should be u
with umlaut.
Any idea ?
I quote from the URL:
The _most_popular_ is presented below.
For single byte code pages I don't see a reason not to support all 255
characters and do whatever the DB code page mandates.
Anyway, the easiest workaround is probably to imply write a trivial UDF
in C/Java/CLR which does the job.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau wrote:
Gregor Kovac( wrote:
>Hi!
Does DB2 handle extended ASCII table?
Example:
VALUES(CHR(65) ) =A
VALUES(CHR(129 )) =null, but according to www.asciitable.com should be u
with umlaut.
Any idea ?
I quote from the URL:
The _most_popular_ is presented below.
For single byte code pages I don't see a reason not to support all 255
characters and do whatever the DB code page mandates.
Anyway, the easiest workaround is probably to imply write a trivial UDF
in C/Java/CLR which does the job.
Of course a big case expression will also work ;-)
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau wrote:
Serge Rielau wrote:
>Gregor Kovac( wrote:
>>Hi!
Does DB2 handle extended ASCII table?
Example:
VALUES(CHR(65 )) =A
VALUES(CHR(12 9)) =null, but according to www.asciitable.com should be
u with umlaut.
Any idea ?
I quote from the URL:
The _most_popular_ is presented below.
For single byte code pages I don't see a reason not to support all 255
characters and do whatever the DB code page mandates.
Anyway, the easiest workaround is probably to imply write a trivial UDF
in C/Java/CLR which does the job.
Of course a big case expression will also work ;-)
Cheers
Serge
Hmmm....
The thing is that I have to replace some characters in a VARCHAR field.
For example: Č (C with a caron) goes into CHR(219). I'm not sure quite what
are you talking about.
Best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Gregor Kovač wrote:
Serge Rielau wrote:
>Serge Rielau wrote:
>>Gregor Kovac( wrote:
Hi!
Does DB2 handle extended ASCII table?
Example:
VALUES(CHR(6 5)) =A
VALUES(CHR(1 29)) =null, but according to www.asciitable.com should be
u with umlaut.
Any idea ?
I quote from the URL:
The _most_popular_ is presented below.
For single byte code pages I don't see a reason not to support all 255
characters and do whatever the DB code page mandates.
Anyway, the easiest workaround is probably to imply write a trivial UDF
in C/Java/CLR which does the job.
Of course a big case expression will also work ;-)
Cheers
Serge
Hmmm....
The thing is that I have to replace some characters in a VARCHAR field.
For example: Č (C with a caron) goes into CHR(219). I'm not sure quite what
are you talking about.
Best regards,
Kovi
CREATE FUNCTION extendedchr(arg INT) RETURNS CHAR(1)
RETURN CASE WHEN arg BETWEEN 0 AND 127 THEN CHR(arg)
WHEN arg = 219 THEN 'Č'
END
Wouldn't that work?
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau wrote:
Gregor Kovač wrote:
>Serge Rielau wrote:
>>Serge Rielau wrote:
Gregor Kovac( wrote:
Hi!
>
Does DB2 handle extended ASCII table?
Example:
VALUES(CHR( 65)) =A
VALUES(CHR( 129)) =null, but according to www.asciitable.com should
be u with umlaut.
>
Any idea ?
I quote from the URL:
The _most_popular_ is presented below.
For single byte code pages I don't see a reason not to support all 255
characters and do whatever the DB code page mandates.
Anyway, the easiest workaround is probably to imply write a trivial UDF
in C/Java/CLR which does the job.
Of course a big case expression will also work ;-)
Cheers
Serge
Hmmm....
The thing is that I have to replace some characters in a VARCHAR field.
For example: Č (C with a caron) goes into CHR(219). I'm not sure quite
what are you talking about.
Best regards,
Kovi
CREATE FUNCTION extendedchr(arg INT) RETURNS CHAR(1)
RETURN CASE WHEN arg BETWEEN 0 AND 127 THEN CHR(arg)
WHEN arg = 219 THEN 'Č'
END
Wouldn't that work?
Hmm.. Not exactly, because the right way to write this FUNCTION would be:
CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(A) = 219 THEN CHR(219)
END
The problem is that I cannot get CHR(219) to display properly.
Best regards,
Kovi
P.S.: I'm preparing the database for you, but I have a problem deleting
large tables. How would you recommend deleting a table really fast? The
problem is that I do not want to drop tables. :))
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Gregor Kovač wrote:
Serge Rielau wrote:
>Gregor Kovač wrote:
>>Serge Rielau wrote:
Serge Rielau wrote:
Gregor Kovac( wrote:
>Hi!
>>
>Does DB2 handle extended ASCII table?
>Example:
>VALUES(CHR (65)) =A
>VALUES(CHR (129)) =null, but according to www.asciitable.com should
>be u with umlaut.
>>
>Any idea ?
I quote from the URL:
The _most_popular_ is presented below.
For single byte code pages I don't see a reason not to support all 255
character s and do whatever the DB code page mandates.
>
Anyway, the easiest workaround is probably to imply write a trivial UDF
in C/Java/CLR which does the job.
Of course a big case expression will also work ;-)
Cheers
Serge
Hmmm....
The thing is that I have to replace some characters in a VARCHAR field.
For example: Č (C with a caron) goes into CHR(219). I'm not sure quite
what are you talking about.
Best regards,
Kovi
CREATE FUNCTION extendedchr(arg INT) RETURNS CHAR(1)
RETURN CASE WHEN arg BETWEEN 0 AND 127 THEN CHR(arg)
WHEN arg = 219 THEN 'Č'
END
Wouldn't that work?
Hmm.. Not exactly, because the right way to write this FUNCTION would be:
CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(A) = 219 THEN CHR(219)
END
Uhm.. isn't that a no-op?
If you have problems with display in CLP or wherever that sounds like a
code page problem.
P.S.: I'm preparing the database for you, but I have a problem deleting
large tables. How would you recommend deleting a table really fast? The
problem is that I do not want to drop tables. :))
ALTER TABLE T ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
COMMIT;
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau wrote:
Gregor Kovač wrote:
>Serge Rielau wrote:
>>Gregor Kovač wrote:
Serge Rielau wrote:
Serge Rielau wrote:
>Gregor Kovac( wrote:
>>Hi!
>>>
>>Does DB2 handle extended ASCII table?
>>Example :
>>VALUES(CH R(65)) =A
>>VALUES(CH R(129)) =null, but according to www.asciitable.com should
>>be u with umlaut.
>>>
>>Any idea ?
>I quote from the URL:
>The _most_popular_ is presented below.
>For single byte code pages I don't see a reason not to support all
>255 characters and do whatever the DB code page mandates.
>>
>Anyway, the easiest workaround is probably to imply write a trivial
>UDF in C/Java/CLR which does the job.
Of course a big case expression will also work ;-)
>
Cheers
Serge
>
Hmmm....
The thing is that I have to replace some characters in a VARCHAR field.
For example: Č (C with a caron) goes into CHR(219). I'm not sure quite
what are you talking about.
Best regards,
Kovi
CREATE FUNCTION extendedchr(arg INT) RETURNS CHAR(1)
RETURN CASE WHEN arg BETWEEN 0 AND 127 THEN CHR(arg)
WHEN arg = 219 THEN 'Č'
END
Wouldn't that work?
Hmm.. Not exactly, because the right way to write this FUNCTION would be:
CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(A) = 219 THEN CHR(219)
END
Uhm.. isn't that a no-op?
If you have problems with display in CLP or wherever that sounds like a
code page problem.
I'm sorry. This should be like this:
CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(C) = 219 THEN CHR(219)
END
I don't see the right output in my DB tool (DbVisualizer) and also not in
db2 interactive mode.
>P.S.: I'm preparing the database for you, but I have a problem deleting
large tables. How would you recommend deleting a table really fast? The
problem is that I do not want to drop tables. :))
ALTER TABLE T ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
COMMIT;
Hmm.. Running this give me:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1596N WITH EMPTY TABLE cannot be specified for "TABLE1".
SQLSTATE=42928
Docs say that when specifying WITH EMPTY TABLE:
"A partitioned table with attached data partitions cannot be emptied
(SQLSTATE 42928"
But this table is not partitioned.
>
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Gregor Kovač wrote:
Serge Rielau wrote:
>Gregor Kovač wrote:
>>Serge Rielau wrote:
Gregor Kovač wrote:
Serge Rielau wrote:
>
>Serge Rielau wrote:
>>Gregor Kovac( wrote:
>>>Hi!
>>>>
>>>Does DB2 handle extended ASCII table?
>>>Exampl e:
>>>VALUES(C HR(65)) =A
>>>VALUES(C HR(129)) =null, but according to www.asciitable.com should
>>>be u with umlaut.
>>>>
>>>Any idea ?
>>I quote from the URL:
>>The _most_popular_ is presented below.
>>For single byte code pages I don't see a reason not to support all
>>255 characters and do whatever the DB code page mandates.
>>>
>>Anyway, the easiest workaround is probably to imply write a trivial
>>UDF in C/Java/CLR which does the job.
>Of course a big case expression will also work ;-)
>>
>Cheers
>Serge
>>
Hmmm....
>
The thing is that I have to replace some characters in a VARCHAR field.
For example: Č (C with a caron) goes into CHR(219). I'm not sure quite
what are you talking about.
>
Best regards,
Kovi
CREATE FUNCTION extendedchr(arg INT) RETURNS CHAR(1)
RETURN CASE WHEN arg BETWEEN 0 AND 127 THEN CHR(arg)
WHEN arg = 219 THEN 'Č'
END
Wouldn't that work?
Hmm.. Not exactly, because the right way to write this FUNCTION would be:
CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(A) = 219 THEN CHR(219)
END
Uhm.. isn't that a no-op?
If you have problems with display in CLP or wherever that sounds like a
code page problem.
I'm sorry. This should be like this:
CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(C) = 219 THEN CHR(219)
END
I don't see the right output in my DB tool (DbVisualizer) and also not in
db2 interactive mode.
>>P.S.: I'm preparing the database for you, but I have a problem deleting
large tables. How would you recommend deleting a table really fast? The
problem is that I do not want to drop tables. :))
ALTER TABLE T ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
COMMIT;
Hmm.. Running this give me:
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL1596N WITH EMPTY TABLE cannot be specified for "TABLE1".
SQLSTATE=42928
Docs say that when specifying WITH EMPTY TABLE:
"A partitioned table with attached data partitions cannot be emptied
(SQLSTATE 42928"
But this table is not partitioned.
OK, well then what about doing a LOAD REPLACE or IMPORT REPLACE?
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
IOD Conference http://www.ibm.com/software/data/ond...ness/conf2006/
Serge Rielau wrote:
Gregor Kovač wrote:
>Serge Rielau wrote:
>>Gregor Kovač wrote:
Serge Rielau wrote:
Gregor Kovač wrote:
>Serge Rielau wrote:
>>
>>Serge Rielau wrote:
>>>Gregor Kovac( wrote:
>>>>Hi!
>>>>>
>>>>Does DB2 handle extended ASCII table?
>>>>Example :
>>>>VALUES( CHR(65)) =A
>>>>VALUES( CHR(129)) =null, but according to www.asciitable.com
>>>>shoul d be u with umlaut.
>>>>>
>>>>Any idea ?
>>>I quote from the URL:
>>>The _most_popular_ is presented below.
>>>For single byte code pages I don't see a reason not to support all
>>>255 characters and do whatever the DB code page mandates.
>>>>
>>>Anyway , the easiest workaround is probably to imply write a trivial
>>>UDF in C/Java/CLR which does the job.
>>Of course a big case expression will also work ;-)
>>>
>>Cheers
>>Serge
>>>
>Hmmm....
>>
>The thing is that I have to replace some characters in a VARCHAR
>field. For example: Č (C with a caron) goes into CHR(219). I'm not
>sure quite what are you talking about.
>>
>Best regards,
> Kovi
CREATE FUNCTION extendedchr(arg INT) RETURNS CHAR(1)
RETURN CASE WHEN arg BETWEEN 0 AND 127 THEN CHR(arg)
WHEN arg = 219 THEN 'Č'
END
>
Wouldn't that work?
Hmm.. Not exactly, because the right way to write this FUNCTION would
be: CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(A) = 219 THEN CHR(219)
END
Uhm.. isn't that a no-op?
If you have problems with display in CLP or wherever that sounds like a
code page problem.
I'm sorry. This should be like this:
CREATE FUNCTION extendedchr(CHA R C) RETURNS CHAR(1)
RETURN CASE WHEN ASCII(C) BETWEEN 0 AND 127 THEN C
WHEN ASCII(C) = 219 THEN CHR(219)
END
I don't see the right output in my DB tool (DbVisualizer) and also not in
db2 interactive mode.
>>>P.S.: I'm preparing the database for you, but I have a problem deleting
large tables. How would you recommend deleting a table really fast? The
problem is that I do not want to drop tables. :))
ALTER TABLE T ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE;
COMMIT;
Hmm.. Running this give me:
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it returned:
SQL1596N WITH EMPTY TABLE cannot be specified for "TABLE1".
SQLSTATE=429 28
Docs say that when specifying WITH EMPTY TABLE:
"A partitioned table with attached data partitions cannot be emptied
(SQLSTATE 42928"
But this table is not partitioned.
OK, well then what about doing a LOAD REPLACE or IMPORT REPLACE?
Yes, I can do this, but ( :)) ) when I try to use IMPORT REPLACE it wants me
to drop tables that have foreign keys to the one im importing to. Ahh....
Any suggestions? I've also tried LOAD REPLACE, but didn't succeed with it.
I was using command:
LOAD FROM TABLE1.IXF OF IXF REPLACE INTO TABLE1
and it was working ok. :)
Thanks and best regards,
Kovi
--
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
| In A World Without Fences Who Needs Gates? |
| Experience Linux. |
-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~- This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: |
last post by:
Hey all,
Quick question...been bugging me for some time, really. I have a console app, it does some things, and I want to save an array of text to a text file. The text consists of ASCII and extended ascii (codes 0 to 255). I am using ofstream to output, and this is the line doing the actual output:
outfile << screenbuffer.Char.AsciiChar;
Note that screenbuffer is an array of type 'CHAR_INFO', quick info of it here:
...
|
by: bgbauer70 |
last post by:
My appologies if this ends up being a duplicate post. For some reason the
first post never showed up.
I've tried about 300 iterrations of this same ability, and none of them seem
to work in Firefox. Take the following code for example. It WILL stop me
from entering zero into the first text box, but it wont stop me from
entering extended ascii characters (which is the final goal).
|
by: kristofvdw |
last post by:
Hi,
I have to treat a given text file, but haven't got a clue which
extended ASCII set it is using.
Opening the file in Windows' Notepad or in DOS, all accented letters
and symbols are wrong.
Any idea how to identify the subset used?
Is there some text editor which can cycle easy through all known
subsets, or even better: cycle subsets automatically until found a
given test-string with some accents and symbols?
|
by: wob |
last post by:
Many thanks for those who responded to my question of "putting greek char
into C string". In searching for an solution, I noticed that there are more
than one version of "Extended ASCII characters"(No. 128 to 255) . e.g., in
one version No. 224 is the symbol alpha, in another, it's a "a" with a ` on
it... How come?
You can see it here:
http://www.kturby.com/cables/ascii2.htm
|
by: Blent stn |
last post by:
Hi,
im trying to upload somefiles using sockets to a FTP site.
But i've some problems with extended ascii characters.
When i try "MKD blent" the created folder is "blent".
The directory name is kept in a string.
What should i convert its encoding to?
If you have any idea to solve this, please reply.
Thanks
| | |
by: JSM |
last post by:
Hi,
I am just trying to port an existing simple encryption routine to C#. this
routine simply adds/substracts 10 ascii characters to each character in a
text file (except quotes). The routine for decrypting the file works fine
however when I encrypt the file, several characters are corrupted. when I
looked into it they are always extended ascii characters (eg "x" which is
ascii character 120 gets translated to ascii character 130 which...
|
by: =?Utf-8?B?Um9zaGFuIFIuRA==?= |
last post by:
Hi All,
I am new to C# programming; I am developing an application for recording
audio data using voice modem.
I am using HyperTerminal to manually process audio data. The modem when
configured in voice record mode sends the audio (PCM) data on the serial
port, few of the characters from these are in Extended ASCII range i.e. more
than 127 decimal.
In HyperTerminal we can reset the property to force the incoming data to 7
bit ASCII,...
|
by: s123 |
last post by:
Hi,
while invoking a web service, if in xml request message i wrap the extended ASCII characters with CDATA it is not returning the desired result, while this is not the case if i do not wrap them with CDATA.
I can not ignore the use of CDATA as for characters "<" and "&" i need to use it. I am not getting why it is not recognizing the Extended ASCII characters correctly when they are wrapped with CDATA, the problem is there only with DB2...
|
by: ramif |
last post by:
Is there a way to print extended ASCII in C??
I tried to code something, but it only displays strange symbols.
here is my code:
main()
{
char chr = 177; //stores the extended ASCII of a symbol
printf("Character with an ascii code of 177: %c \n", chr);
//tries to print an ASCII symbol...
|
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, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets 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: 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...
|
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 projectplanning, coding, testing, and deploymentwithout 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...
|
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: 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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
