php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #76091 icu_load_collation in sqlite.
Submitted: 2018-03-13 16:13 UTC Modified: 2018-09-24 17:48 UTC
From: alejosimon at gmail dot com Assigned: cmb (profile)
Status: Closed Package: PDO SQLite
PHP Version: Irrelevant OS: Windows 7 x64 SP1
Private report: No CVE-ID: None
 [2018-03-13 16:13 UTC] alejosimon at gmail dot com
Description:
------------
Hello, I need load more collations for use into sqlite pdo driver and use this method:

SELECT icu_load_collation('de_DE', 'de_DE') (for example)

and see this error:

SELECT icu_load_collation('de_DE', 'de_DE')

Code: HY000, SQLSTATE[HY000]: General error: 1 no such function: icu_load_collation, in....

Test script:
---------------
<?php

 $pdo = new \PDO( ':memory:' ) ;

 $pdo->query( 'SELECT icu_load_collation('de_DE', 'de_DE')' );

?>

Expected result:
----------------
suppoted ICU from SQLITE too.

Actual result:
--------------
Code: HY000, SQLSTATE[HY000]: General error: 1 no such function: icu_load_collation, in....

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2018-09-24 17:48 UTC] cmb@php.net
-Status: Open +Status: Closed -Assigned To: +Assigned To: cmb
 [2018-09-24 17:48 UTC] cmb@php.net
To use the SQLite ICU extension[1], you'd have to load it first.
This is, however, not yet supported, but requested in request
#64810.

[1] <https://www.sqlite.org/src/artifact?ci=trunk&filename=ext/icu/README.txt>
 
PHP Copyright © 2001-2020 The PHP Group
All rights reserved.
Last updated: Sat Sep 19 14:01:24 2020 UTC