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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: alejosimon at gmail dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved.
Last updated: Mon Jan 06 06:01:29 2025 UTC