Hi Ian,

My vi won't do ^K but my vim will!

In vi and xvile I've found that ^V is the way to go.
.. By decimal value: ^Vnnn (with 000 <= nnn <= 255)
.. By octal value: ^VOnnn or ^Vonnn (with 000 <= nnn <= 377)
.. By hex value: ^VXnn or ^Vxnn (with 00 <= nn <= FF)
.. By hex value for BMP Unicode codepoints: ^Vunnnn (with 0000 <= nnnn <= FFFF)
.. By hex value for any Unicode codepoint: ^VUnnnnnnnn (with 00000000 <= nnnnnnnn <= 7FFFFFFF)

The Perl pragma charnames is also pretty damn handy.

Marty

-----Original Message-----
From: Ian Kirkham [mailto:Ian.Kirkham (AT) actian (DOT) com]
Sent: 14 October 2011 15:12
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Select, escaping special chars

Hi Marty,
I use vi to build the diacriticals as my keyboard is not very good with languages, (even English spelling it finds taxing).
In vi use control-k followed by a' or a` or n~ etc. then cut and paste ...
Regards,
Ian
-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com [mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of Martin Bowes
Sent: 14 October 2011 14:38
To: Ingres and related product discussion forum
Cc: Paul Mason
Subject: Re: [Info-Ingres] Select, escaping special chars

Hi Paul,

Oh that's sweet! But I take it that this can't be done after the database is created with another collation.

And on anoter point...how the hell did you enter the á etc at a standard keyboard?

Marty
-----Original Message-----
From: Paul Mason [mailto:Paul.Mason (AT) actian (DOT) com]
Sent: 14 October 2011 11:55
To: Ingres and related product discussion forum
Subject: Re: [Info-Ingres] Select, escaping special chars

One thing you can do - which may not be appropriate depending on your needs - is create a custom collation sequence. The collation sequence determines what "weight" individual characters have and therefore the order in which they sort. It's possible to define similar characters to have the same weight.

You do this by creating a text file that describes the collation sequence (.dsc) and compiling it with aducompile. You then set the collation sequence when you create the database using the -l flag

E.g.

a:â
a:ã
a:ä

Creating DBMS System Catalogs . . .
Modifying DBMS System Catalogs . . .
Creating Standard Catalog Interface . . .
Creating Front-end System Catalogs . . .

Creation of database 'collatedb' completed successfully.

Ingres Linux Version II 10.1.0 (int.lnx/00)NPTL login
Fri Oct 14 10:42:03 2011
continue
* * * /* SQL Startup File */
CREATE TABLE test (col1 INTEGER NOT NULL,
col2 VARCHAR(20) NOT NULL)
Executing . . .

continue
* * * * * * * * INSERT INTO test VALUES (1, 'Cháteau');
INSERT INTO test VALUES (2, 'Château');
INSERT INTO test VALUES (3, 'Chãteau');
INSERT INTO test VALUES (4, 'Chäteau');
INSERT INTO test VALUES (5, 'Chateau');
INSERT INTO test VALUES (6, 'xyz');
INSERT INTO test VALUES (7, 'abc');
Executing . . .

(1 row)
(1 row)
(1 row)
(1 row)
(1 row)
(1 row)
(1 row)
continue
* * * SELECT * FROM test
WHERE col2 = 'Chateau'
Executing . . .


+-------------+--------------------+
(5 rows)
continue
* * * SELECT * FROM test
WHERE col2 LIKE '%a%'
Executing . . .


+-------------+--------------------+
(6 rows)
continue
* * * SELECT * FROM test
ORDER BY col2
Executing . . .


+-------------+--------------------+
(7 rows)
continue
* * SELECT DISTINCT col2 FROM test
Executing . . .


+--------------------+
(3 rows)
continue
*
Your SQL statement(s) have been committed.

Ingres Version II 10.1.0 (int.lnx/00)NPTL logout
Fri Oct 14 10:42:03 2011

The downsides are that

a) as you can see above you lose the ability to distinguish between those values (see the SELECT DISTINCT query)

b) since it needs setting when the database is created, an existing database would need to be unloaded and then reloaded.

As I say these downsides may outweigh the benefit.

HTH
Paul



_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres

On Oct 18, 3:53*pm, seldomisnice... (AT) gmail (DOT) com wrote:
Do you have an example of how to do this? I'm wasn't aware iconv could
do that.

Here is a demo that shows some problems, I'd be interested in any
extra options iconv has that could help:

$ python -c 'mystr = u"Bj\N{LATIN SMALL LETTER O WITH DIAERESIS}
rk";print mystr.encode("utf8")' | iconv --from-code utf8 --to-code us-
ascii
Bjiconv: illegal input sequence at position 2

$ python -c 'mystr = u"Bj\N{LATIN SMALL LETTER O WITH DIAERESIS}
rk";print mystr.encode("utf8")' | iconv --from-code utf8 --to-code us-
ascii -c
Bjrk
$

The later one appear to work but note that it is missing a character!


Chris

Hi All,

I have been asked to look into PHP and Ingres for some (small and possibly
large) web solutions required by a client...

I have seen, from time to time, mention of PHP in this forum and was
wondering what people prefer in PHP (free/open source) frameworks?

I am sorry that this is not a direct ingres question but you guys are more
informative than some of the other forums out there.

I have had a little look at things like CodeIgniter, CakePHP, Symfony, etc.
There is any awful lot of information on the web but I am having troubles
making a decision - still not sure what questions to ask.

Any help would be greatly appreciated.

Regards,
Andy.

yes! It's just
iconv -f iso-88591 -t ascii//translit

I don't have the exact syntax because I'm not on the unix machine right now but something like that.
I guess the translit does the approximation to the ascii character.
Cheers

On Oct 20, 2:23*pm, Chris <Chris.Clark (AT) actian (DOT) com> wrote:

To follow up, seldomisnice posted the option "//translit" (note the
double slash) to the encoding name, there is a corresponding //IGNORE
(which is the charset name equivalent of using the -c flag).

Demo:

$ python -c 'mystr = u"Bj\N{LATIN SMALL LETTER O WITH DIAERESIS}
rk";print mystr.encode("utf8")' | iconv --from-code utf8 --to-code us-
ascii//translit
Bjork

I assu 'sf escorts' (http://www.sfasianescorts.com) I accidentally cut
it on with the drives out

'sf asian escorts' (http://www.sfasianescorts.com) Now drives 1-3

and the power button are on constantly and drive 4 is flashing. And I

can't locate it in raidar etc. If so any idea of how long ti would take


all four 'sf escort' (http://www.sfasianescorts.com) I'm waiting to

'sf asian escort' (http://www.sfasianescorts.com) migrate my data to
my Ultra


--
xliang